Adding fiilters in reports.

[neosam]

Hi,

This is wierd.... I had given filters to a report and when a cmd button is clicked, the filtered report (Data having a particular date) is opened. This worked fine yesterday. but today it is not filtering the data in the report... Could someone tell me i have edited the coding by mistake?

DoCmd.OpenReport "ReportName", acViewPreview, , "Date >= From_Date" & "< To_Date"

[JKing]

Hi,

This is wierd.... I had given filters to a report and when a cmd button is clicked, the filtered report (Data having a particular date) is opened. This worked fine yesterday. but today it is not filtering the data in the report... Could someone tell me i have edited the coding by mistake?

DoCmd.OpenReport "ReportName", acViewPreview, , "Date >= From_Date" & "< To_Date"

I think your where criteria is malformed.

You either want:

DoCmd.OpenReport "ReportName", acViewPreview, , "Date >= From_Date AND Date <= To_Date"

'or alternatively if you are referencing controls on a form

DoCmd.OpenReport "ReportName", acViewPreview, , "Date >= #" & Me.From_Date & "# AND Date <= #" & Me.To_Date & "#"

[neosam]

I think your where criteria is malformed.

You either want:

DoCmd.OpenReport "ReportName", acViewPreview, , "Date >= From_Date AND Date <= To_Date"

'or alternatively if you are referencing controls on a form

DoCmd.OpenReport "ReportName", acViewPreview, , "Date >= #" & Me.From_Date & "# AND Date <= #" & Me.To_Date & "#"

Dude,

You are a life saver......

[JKing]

Dude,

You are a life saver......

Haha,

You're welcome :)

Jared