Adding Date Range to Report

[MR via AccessMonster.com]

I have a report called “rptActivityReportâ€. This report is made up of many
queries. How can I add a date range to the report?

For example, the user will enter a date range [1/7/06] and [8/19/07] and the
report will auto populate all the textboxes with the query results form all
the queries with the date ranges.

Is this possible? If so, how do I going about do it?

 

[KARL DEWEY]

For example, the user will enter a date range [1/7/06] and [8/19/07] and
the report will auto populate all the textboxes with the query results
Assuming the dates are inputted at a prompt copy the criteria into a new
field row of the query design view like this ---
Expr1: [Enter start date]
and second criteria in another like this ---
Expr2: [Enter end date]

If the dates are typed in a form copy the criteria into a new field row of
the query design view like this ---
Expr1: [Forms]![YourFormName]![YourTextBox_1]
and second criteria in another like this ---
Expr2: [Forms]![YourFormName]![YourTextBox_2]

You can name Expr1 & Expr2 anything you want then use them in your report.