N Niggles Apr 2, 2004 #1 I have three queries but i wish to display on one report using each query as a group how do i do this
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 Apr 2, 2004 #2 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
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
