Combining several queries into a single table 1

[Cypdog]

I have 11 queries that all have the same data structure but arrive at their contents differently because they are all built for different scenarios/instances that I am dealing with. The content of each query is structured that each could be exported to excel and appended to each other seamlessly to create a master excel file which can then be manipulated. Is there a way to combine all of these into a table that can be exported, preferably with out running 11 append queries.

Thanks so much for any light you can shed on this.

 

[Lothario]

DO a UNION ALL query.

-L

 

[Cypdog]

Thanks, that worked great, I was hoping at first that I was going to get away with out doing anything with sql but I learned what I needed to and it did not hurt. Thanks again.