Combining Parameter Queries with Results in a Form

  • Thread starter Thread starter Staci
  • Start date Start date
S

Staci

Hello. Help, please!

I have one database from which I am extracting sums and
counts based on actual date and/or >=date (plan numbers
vs. actual numbers both weekly and accumulative). I have
had to develop four queries to obtain this information
accurately. Since the date will always be the same, I've
structured the four queries as parameter queries.

Everything works fine until I create my report. I have to
enter the parameter date 4 times. I would like to enter
the date one time and have the report generate.

If I combine the results of the four queries (in another
query or make table) I'm still required to enter the date
4 times.

Any suggestions?
 
You can create a form that will have the parameter(s) that
you need for your queries and kick off your report.
 
I was looking into that. Is it possible to create the
form so that the date only has to be entered one time
even though the parameters are needed for four different
queries?

Thanks for your response!
 
Back
Top