Report Filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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
 
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.
 
Back
Top