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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

append with union query? 6
Union Query 2
Single WHERE and ORDER clause in UNION? 4
Union Query and Field Alias 7
Run Make Table Query on Union Query 2
MS 2003 Parameterized Query 0
Make-Table AND Union Query 2
SUM in a UNION query 2

Back
Top