Where Condition

S

Stefan

I am trying to open a report from a form filtering it with
the fromdate and dateto fields. I have this line of code

DoCmd.OpenReport stDocName, acViewPreview, , "[qry Average
# Patient Visits]![Date From] Between Me![FromDate] and Me!
[DateTo]"

I get a msgbox asking for parameters for [date from]. The
first part of the where clause is the qry the report is
based on and the field I am filtering.

I am a newbie to vba and appreciate the help
 

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

Top