How to link a report to multiple queries?

[AnnaZ]

Hello,

I have multiple queries that I need to display in one report, I was wondering how I can do that?
Also, I need to total some numbers from those separate queries - how can I connect the data from several queries, so that I could total some of the fields?

Thanks in advance.

 

[Crilen007]

Providing they have the same fields

you can do a union query

Select * from qry1 UNION ALL Select * from qry2 UNION ALL select * from qry3;