Date Range

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

Guest

I am trying to set a date range to open a report and I can't figure out how
to do it.
 
I am trying to set a date range to open a report and I can't figure out how
to do it.
Click to expand...

Here is the basic method.
Create a query to be used as the report's record source.
As criteria on the DateField, write:
Between [StartDate] and [EndDate]

When you open the report, it will prompt you to enter the 2 dates.
 
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

Excel Highlight date ranges 1
Date search query 0
Date Range 3
Date Range on Report 6
Year Comparison Report 6
Matching date range in subreports 7
Subreport in Report Obtains Wrong Date With Query Criteria 10
Crosstab Query and Date Parameters 10

Back
Top