Combining several queries into 1 report

[User Name]

What is the best way to combine data from several queries (all data from 1 table) into a report? I want to group data from the table an have accomplished this by creating 7 queries representing the 7 headings I wish to present. How can use a report to present all of this data, hopefully without using subreports? 7 queries to one report.

 

[dcx693]

I'll tell you how to combine the queries into one but first I'd like to ask why you split your data into 7 queries if they're all from the same table. It wasn't just to feed them into one report with a calculated heading column was it?

Reports will only accept a single data source, so you'll need to combine all 7 queries into one using union queries. Basically the syntax is like this:
first SQL statement
UNION (second SQL statement UNION (third SQL statement(etc...)))

Look up the topic in the Access help.