Between 2 dates

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

Guest

I have a report set up with multiple subreports inside. I would like the user
to be able to enter in a start date and an end date and for the report to
show data only from that time period. Because I have multiple subreports when
I ask for a start and end date the database requires the user to enter a date
for each subreport. I only want them to have to enter in a date once. Any
suggestions.
 
Assuming you have a text box on your form for each date, go to the query you
are using as the record source for your form/report and in the date criteria
field:

Between [forms]![Myform]![txtboxbegin] AND [forms]![Myform]![txtboxend]
 
You must log in or register to reply here.

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

Similar Threads

How to limit Parameters 7
Subreport in Report Obtains Wrong Date With Query Criteria 10
Reports/SubReports 2
Matching date range in subreports 7
Report works ok but not subreport 6
subreports 1
Running Query on memo field - character limit 4
Report asks for Parameter and Won't Display Subreport 7

Back
Top