Two queries in one report

  • Thread starter Thread starter Love Buzz
  • Start date Start date
L

Love Buzz

Hi all.

I have what is probably an easy question (and hopefully has an easy solution
:D).

I have a report that I would like to reflect the results of two queries,
that come from the same table. I am not having much luck.

What is the easiest way to go about bringing in the results of two queuries
into one report?

Thanks for your help.
 
A report can have only one record source (1 query or table). If you have
two queries, you will need to either find a way to combine the two queries or
use one query for the report and the other in a subreport.

If there are common fields on which you can join the two queries, you could
create a third query that uses your two current queires, join them and use
that as the report's record source.
 
If you use a union query as the third query to combine the two current
queires for the report's record source you can add another field for Sorting
and Grouping so all of first query records appear first.
 
Back
Top