Make-Table AND Union Query

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
 
J

John Vinson

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]
 
Top