Combine like output of 12 queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 12 queries that are designed like these...

qry1
part month amount
a 1 100

qry2
part month amount
a 2 50
b 2 75

qry3
part month amount
a 3 100
c 3 45

etc....

all the query have the same column names.
I want one query that will show a combination of all like data..

For example....
Final combined query
part month amount
a 1 100
a 2 50
a 3 100
b 2 75
c 3 45


Any input would be greatly appreciated...
 
Take a look at Access HELP on the UNION query.

(Could you describe why you need 12 different queries? I suspect you have
either twelve tables - for the months - or you are trying to summarize a
single table by month -- If the latter, use a Totals query instead. If the
former, consider normalizing your data structure.)

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top