Can a Union also be a Make Table?

E

ed finley

I'm trying to get a union query to also be a make table query. Is this
possible and where would the INTO clause need to go.
Thanks in advance,
Ed
 
J

Jeff Boyce

Ed

I don't know how you would "convert" a UNION query into a make table query,
but there is another solution.

Create your UNION query, then create a new query, using the UNION query as
its source. Change that SECOND query to a make table-type query.
 
Top