SQL question: create table from a UNION query

[amyjay123]

I've got an (admittedly rather nasty) query which selects fields from multiple tables (let's call them 1, 2, 3) (which have common field names) and racks them on top of each other, alongside another table (called 'a'), where values in one 'a' field = a value in a corresponding field in 1, 2 or 3.

The only way I've managed to do this is the nasty UNION query, and I can't for the life of me figure out how to create a table from it (for which I would usually use SELECT INTO).

I'm fairly certain that this is a silly way of doing it, and I'm sure I'm too rubbish to understand any complex answers,

I'd really appreciate any help,

Amy

 

[Joe4]

What if you create another query, specifically a Make-Table query, from this Union Query of yours?

If you take a look at Access' help on Action Queries, it should instruct you on how to build a Make-Table Query.