Combining multiple tables (similar structure) to one table 2

[dhardie]

I have a total of 8 tables. Identical Structure. Headers on each table are different. I want to combine all into one table. I know that I can use the union query. How do I make a combined table with all 8 tables with minimal operations? Thanks.

 

[SkipVought]

You got it-- 7 Unions!

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]

 

[dhardie]

Is there a way to do multiple "selects" and combine before I make a table?

 

[PHV]

Create a saved query with the 7 UNION
Then create a maketable query based on the previous saved query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244