Appending queries

  • Thread starter Thread starter DKS
  • Start date Start date
D

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.
 
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.
 
But how? how do I create a Union query (where do I indicate that it is a
union that I need).
Click to expand...

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