5 Queries into 1 Query

M

Mr-Re Man

I currently have 5 tables which have been turned into 5 queries.
Each query records details for work to be carried out at different Areas
(ie. Central, East, West, All & Schools)

I generally merge the records from Access into Excel in 5 seperate
worksheets, then copy and paste them into one worksheet.

Is there a way to merge the 5 queries together in Access into 1 'Super'
query and merge these into excel in just 1 worksheet? (as to avoid the cut &
paste)

All the fields in each table/query are the same except for the field (Area)
as mentioned above.

Any help would be appreciated.
 
R

Rick B

If the fields are the same, why do you have five tables? You should have
one table and a field to mark which region.

If you can't do this for some reason (although it would fall within
normalized design if you did) then you would want to create a UNION query to
pull the results from the other five into one.

For help on building a UNION query, either consult the help file or read
previous posts in this newsgroup.
 
Top