
August 16th, 2004, 04:52 PM
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Apply Date Range To Every Page of The Report and SubReport
I created a project status report with a subreport that displays the project details for a specified date range in Access 2000. The subreport is based on a query with a date field criteria of Between [startdate] and [enddate]. When I run the report, Access acurately prompts me for a start date and end date and the first page of the report opens correctly. However, when I go to the next page of the report which is also the information for the next project, I am prompted to re-enter the start date and end date again. How can I apply the start date and end date across all of the project detail subreports, and keep the users from having to enter the date range multiple times?
Thanks,
Chris Haley
chaley@kilpatrickstockton.com
|