Multiple Queries into one report

  • Thread starter Thread starter Niggles
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying info from multiple records in a report 7
Access Sorting and grouping using multiple tables 0
Access Access Report Works on One Machine but not Another 3
Report Sum with Multiple Relationships 2
Multiple tables 1 report 5
Record omission 2
Printing Multiple Subreports in Details 4
Multiple Reports – Same Query – Underlying Data Changes Frequently 1

Back
Top