Filter report and subreport

[Terye N]

Hi, I have a report "votrial" which is based on a query "vototals" which
totals by date for each unit. I want to be able to choose which two weeks to
report (usually but not always, the last two reports.) The field name is
"vodate."

Also on this report, I have a subreport "AdvDir" which comes from a query
"adquery" which returns detail by unit on several different fields. I need
to be able to choose a specific date (usually but not always today) to
report. The field name is "AdDate"

I have linked the tables by "unit" since that is the common element, but
can't seem to be able to pull up specific dates. If I put the parameter in
the query, when I run the report I am asked repeatedly for "AdDate".

Thanks for any and all help!

 

[Allen Browne]

The simplest solution might be to create a form where you enter the dates
for the main report and the subreport. Then click a button on the form to
open the report.

The report's source query will read the data from the form if you use a
parameter like this:
[Forms].[Form1].[Text0]

Same ide in the subreport's query.