Multiple Queries into one report

N

Niggles

I have three queries but i wish to display on one report
using each query as a group how do i do this
 
M

Marshall Barton

Niggles said:
I have three queries but i wish to display on one report
using each query as a group how do i do this
Click to expand...

That's kind of vague, but I'll take a guess that you could
use a UNION query:

SELECT "grp1" As GroupField, table1.*
FROM table1
UNION ALL
SELECT "grp2", table2.*
FROM table2
UNION ALL
SELECT "grp3", table3.*
FROM table3
 
Top