Query criteria between dates

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

Guest

I have set up a query Between[Enter Start Date]and [Enter End Date]. This
works fine in query. I have a sub report that calculates totals this works of
the original query
When I go to report and enter in the dates..I have to keep repeating the
start and End dates repeatedly
It is probably something simple. Does anyone have any clues.
Than you in advance for your help
 
Grant said:
I have set up a query Between[Enter Start Date]and [Enter End Date]. This
works fine in query. I have a sub report that calculates totals this works of
the original query
When I go to report and enter in the dates..I have to keep repeating the
start and End dates repeatedly
Click to expand...

You are prompted each tme the subreport appears in the main
report.

Use a form with two text boxes (named txtStart and txtEnd)
for the user to enter the start and end dates. Also add a
command button to open the report (there's a wizard that
will create the code for you).

Then change the query parameters from the prompt strings to
reference the form text boxes.

Between Forms!theform.txtStart AND Forms!theform.txtEnd
 
Back
Top