Make table using Union Query

[kfowlow]

Last week I put a question to the board on how to make a union between two
tables. The board put me strainght and I can now male one. Not what I want to
do is to make a table out of this Union Query. I am adding one column in 4
tables to produce one large table. I cannot find the right code to make the
Union Query save the data as a table. Can anyone help? If I can't make a
table from a Union Query, what other options do I have.

Thanks,
Keith

 

[BobT]

The simplest way is to now take your Union query and make it an Inline query.
For example, you might have something like this:

Select *
From Table1
UNION
Select *
From Table2;

Now make it an inline query:

Select *
from
(
Select *
From Table1
UNION
Select *
From Table2
)

You will then be able to view it in the Query By Design grid and flip it
from a SELECT query to a MAKE TABLE query.

 

[kfowlow]

BobT,
Great reply. It worked like a champ. I appreciate the help. I've been
racking my head trying to figure this one out. This will do the trick for me.

I appreciate it a lot.
Thanks,
Keith