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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top