Make-Table AND Union Query

  • Thread starter Thread starter Debris
  • Start date Start date
D

Debris

Hello,

Wrote my first little bit of SQL code tonight, successfully created a union
query. (It's only two lines, but hey I'm proud of it.)

It works just fine as a select query, but when I try and make it a
"make-table" query, I get the error message

"An action query cannot be used as a row source. (Error 3417)"

(I'm sliding an INTO clause into my SQL code.)

Can a union query be a make-table query?

Thanks, D
 
Hello,

Wrote my first little bit of SQL code tonight, successfully created a union
query. (It's only two lines, but hey I'm proud of it.)

It works just fine as a select query, but when I try and make it a
"make-table" query, I get the error message

"An action query cannot be used as a row source. (Error 3417)"

(I'm sliding an INTO clause into my SQL code.)

Can a union query be a make-table query?

Thanks, D
Click to expand...

No... but you can save the UNION query, and base a MakeTable query on
it.

John W. Vinson[MVP]
 

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
Run Make Table Query on Union Query 2
UNION QUERY 2
SUM in a UNION query 2
Union Query and Field Alias 7
Union Query 2
Union Query between 2 or more Queries 6
Need to upate union query statement every month 1

Back
Top