Appending queries

[DKS]

I have 5 different queries that work on 5 different tables.

All the 5 queries return exactly the same number of columns (4) and the
column titles are identical (I have assigned identical column titles).

I want to write a 6th query that presents to me the results of the above 5
queries but appended one after another. I do not need any other processing
at this point in time, a simple appended view of the output.

is there some way of achieving this easily?

Many thanks in anticipation.

 

[Klatuu]

Use a UNION query

 

[DKS]

But how? how do I create a Union query (where do I indicate that it is a
union that I need).

Sorry but in access I am an absolute beginner.

 

[Klatuu]

Try looking in Help. It should explain how it is done.

 

[John W. Vinson]

But how? how do I create a Union query (where do I indicate that it is a
union that I need).

As Dave suggests, the Access Help (search for UNION) is a good place to start.

A UNION query must be built in the SQL window; the query grid isn't capable of
it. You can start by opening one of your queries and selecting View... SQL to
get into the SQL window. You'll see something like

SELECT Who, What, IDontKnow, Why FROM sometable;

Edit this to

SELECT Who, What, IDontKnow, Why FROM sometable
UNION ALL
SELECT Who, What, IDontKnow, Why FROM someplaceelse
UNION ALL
SELECT Who, What, IDontKnow, Why FROM anotherplace

Again - see the help, it's pretty clear.