One filter for six queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in which there are six subreports. I have to do it this way
because of the way the data is broken into sections. However, each query for
each subreport ask Month? Therefore, when I run the report I get the same
question six times. Is there anyway to have it ask the question once for all
six queries/subreports?

Thanks for all your help.
 
margaret said:
I have a report in which there are six subreports. I have to do it this way
because of the way the data is broken into sections. However, each query for
each subreport ask Month? Therefore, when I run the report I get the same
question six times. Is there anyway to have it ask the question once for all
six queries/subreports?
Click to expand...


You definitely need to move beyond using the quick and dirty
query parameter prompts.

Create a simple unbound form with a text box for users to
enter the query parameter value and a command button to open
the report. Then change the queries parameter prompts with
a reference to the text box on the form. Then change the
query criteria from [Enter Month] to
Forms!nameofform.nameoftextbox
 
Marshall:

Thanks so much! That was so easy to do and makes everthing so much better.!

Thanks again.
 
Back
Top