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...
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...