Combine two Union Queries 1

[justagrunt]

Hi,
Due to lack of system resources (the system will allow result of 11 queries but not the full 15 to be joined) I have had to create two union queries (one of 9 and the other of 6 ) to generate the information I require. The two unions can be run separately but a one off proved to be too complex, hence I broke it up into two.How do I go about joining these two, so that the combined information can be exported to a final destination of an Excel spread sheet latter.
I have thought of a make table but the two Union queries have the same field names.
Thanks
Regards
Bill

 

[stix4t2]

Can you create append queries to run all 15 queries into a temp table. Then use the temp table to create the excel spreadsheet. Or link an excel spreadsheet to the database and run the append queries into it.

 

[justagrunt]

Thanks,
Warm regards
Bill