Append queries?

G

George

Hi,
Is it possible to append 4 queries into one new query?
I import 4 different files into the database, I then rework each individual
table in a query that gives all the 4 queries the same format and headers. Is
it possible to now create a query that puts all the 4 reworked queries into
one new query?
Thanks
George
 
D

Duane Hookom

A union query might work. It depends on your definition of "puts all the 4
reworked queries into a new query"/
 
G

George

Hi Duane,
"puts all the 4 queries into a new query" - what i mean here is, as they all
have the same field names. I want to list them all in the one query.
How do i build a union query?
 
D

Duane Hookom

You must do this in the SQL view. Generically...

SELECT FieldA, FieldB, FieldC, FieldD
FROM qryOne
UNION ALL
SELECT FieldA, FieldB, FieldC, FieldD
FROM qryTwo
UNION ALL
SELECT FieldA, FieldB, FieldC, FieldD
FROM qryThree
UNION ALL
SELECT FieldA, FieldB, FieldC, FieldD
FROM qryFour;
 
Top