|
Senior Member
|
|
Dec 11, 2008, 11:57 AM
|
|
I will use letters for fields names (to make it easy)
Create a new query (Change the query type to UNION Query)
SELECT A,B,C,D,E,F,G FROM TABLE1
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE2
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE3
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE4
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE5
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE6
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE7
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE8
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE9
UNION ALL
SELECT A,B,C,D,E,F,G FROM TABLE10
Save it
Then create another query (Set it as a make table)
Use the Unionquery as the source
Make sure you use the union ALL (otherwise it will combine rows that match)
|