merge columns from summary querries

[Claire]

having difficulty merging information in querries
together. Problem may be caused because they are summary
querries. Do I have to make each of these querries a
table before i can merge the data together????

 

[Chris Nebinger]

NO, you don't have to. You can do it using UNION queries
(fairly advanced topic)


If you have 2 queries, query1 and query2 with the same
field names (that's very important), then open a new
query, don't add any fields, then View->SQL

Type:

Select * from Query1
UNION
Select * from Query2


Chris Nebinger