Using the same input variables many times

  • Thread starter Thread starter Kenny Robb
  • Start date Start date
K

Kenny Robb

I have created a report with a number of sub reports.

When I run the Report the first query asks me for a date range.

How can I get the rest of the sub reports to use the same date range
without having to type them in every time.

Thanks in anticipation

Kenny
 
create an unbound form and have the user put the parameter values in the
fields on your form. Then, have the various queries reference those fields.

There are several details to this, review the previous posts on the topic.

Do a search for "Parameter form".
 
Back
Top