merge columns from summary querries

  • Thread starter Thread starter Claire
  • Start date Start date
C

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????
 
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
 
Back
Top