2 queries that create 1 repot

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

Guest

Hello, I have 2 questions. First i have 2 queries that i want the results to
appear in one report and second i want the user to be able to select the
criteria for both queries. Is this possible.

Thanks

-Alfred
 
The answers are Maybe and Yes.
A report can have only one record source, so you will not be able to use
both. However, you could create a sub report and use the second query as the
record source. Another possibility is if there is any way you can create a
third query that will combine the data from the other 2 queries, that could
work.
To allow the user to specify the criteria, create text boxes on your form
for them to enter the parameteres they need. Then in the query where the
paramaters go put something like this in the criteria row for the column you
want the parameter in:
=Forms!MyFormName!MyControlName
 
Thanks for the input. I have tried to query my 2 queries to try and combine
them as one but it seems to be giving me garbage values, any idea on what is
wrong?
 
Sorry, there is no way I can tell with out the tables and the queries in
front of me. It may not be possible.
 
I figured it out thanks alot for all your help

Klatuu said:
Sorry, there is no way I can tell with out the tables and the queries in
front of me. It may not be possible.
Click to expand...
 
Back
Top