Sub Report

[Guest]

I have a main report with a sub report attached to it. When I bring up the
report I have criteria in the queries for a date range. But since I have a
sub report attached it asks for the criteria multiple times. Is there any way
to only have it ask once for the criteria (date range)?

Thanks

 

[Allen Browne]

Create a form with a pair of text boxes where the user can enter the start
date and end date.

You can then have both queries (the query for the main report and the one
for the subreport) read the dates from the form by entering something like
this in the Criteria row under the date field in query design:
Between [Forms].[Form1].[StartDate] And [Forms].[Form1].[EndDate]