Between dates

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

Guest

Hello
I know this is easy but I have forgotten how create a date range in the
Query when opening a report. Meaning when I open a report I have to enter
the from date and to date to get the report.
I hope you can help me I had it working some time ago but now have forgotten
how to enter it into the Query field.
Your help will be much appreciated, thanking you.
Rita
 
You create a form with two text boxes (one for each date value). You can then
either use the values from the text boxes in WHERE CONDITION of the
DoCmd.OpenReport method or reference the form controls in the query criteria.
 
Back
Top