Can a single report use data from multiple queries?

  • Thread starter Thread starter SueB
  • Start date Start date
S

SueB

I have a report that displays the results of a single query. I need to add
the results of another query to the same report but don't know how to go
about that. When I create a new report using the Wizard it asks me which
query or table has the data I want to display and I can pick only one
source. How do I create a report where the data comes from more than one
query?
 
Assuming all underlying queries have the same output columns, you should be
able to create a single query which feeds the report. This single query
could use the UNION operator to select multiple queries:

e.g.

SELECT Col1, Col2 FROM Table1
UNION
SELECT Col1, Col2 FROM Table2
UNION
SELECT Col1, Col2 FROM TableN


You then set this query as the recordsource for the report...

--
Cheers,


James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures
 
Back
Top