Can a Union also be a Make Table?

  • Thread starter Thread starter ed finley
  • Start date Start date
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
 
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.
 
Back
Top