Report Filter

[Brad]

Thanks for taking the time to read my question.

I want to put a filter on my report from a form.

DetailMonthYear = Between #4/1/2007# And #5/1/2007# is what I've tried, and
I don't know what else to do.

DetailMonthYear = 4/1/2007# works.

I'm building the Filter string with code then passing it to the form in the
docmd.OpenReport

Thanks,

Brad

 

[Douglas J. Steele]

What happens when you use the between statement you show?

How exactly are you using the filter with the OpenReport method? (i.e.: show
your code)

 

[krissco]

Instead of "DetailMonthYear = Between #4/1/2007# And #5/1/2007#"
type "DetailMonthYear Between #4/1/2007# And #5/1/2007#" (No equals
sign)

-Kris

 

[Brad]

Thanks Kris...

It worked perfectly!

Brad

 

[mroks]

you can also create a query, under your DetailMonthYear field/Criteria: type
"is not null and between forms!FormName!FieldName(Date From) and forms!
formName!fieldName2(Date to)

on your form

create to field:
Date From and Date to

thanks.