duplicate date entry for report w/ sub reports

[Guest]

I have a report that has two subreports. The queries that the reports are
based on have the criteria "Enter Date". All the reports work fine by
themselves, but on the combined report the Enter Date pop-up reappears 7
times before the report finally opens. Any idea where I am making a mistake
with the date? - the criteria (Enter Date) matches exactly accross all
queries.

thanks
c

 

[Rick B]

You should build a small modal form with a date select field. Have the user
enter the date desired and then click a "print ??? report" button. The
queries should then get their date from that form, not from a pop-up
parameter.

Do a search and you should find many examples of parameters in a form.

Rick B

 

[Rick B]

Another option (depending on the data used) is to build a query that pulls
all the records for the entered date, then base your other 7 queries off of
that one query. This may not work depending on what you are pulling and how
much data is needed from various sources.

Rick B

 

[Guest]

Thanks Rick

Another option (depending on the data used) is to build a query that pulls
all the records for the entered date, then base your other 7 queries off of
that one query. This may not work depending on what you are pulling and how
much data is needed from various sources.

Rick B