XXX Action Query XXX

B

bladelock

My code in an SQL Query
SELECT [A Yes] as TheValu
from Query
WHERE (([A Yes]) Is Not Null

Union al
select [B Yes
from Query
WHERE (([B Yes]) Is Not Null)

PROBLEM
I want to write this data to a TABL
I tried putting:
SELECT [A Yes] as TheValue INTO NewTabl

error "An action query cannot be used as a row source" HELP!!!
 
D

Duane Hookom

Did you try saving your union query and then using it as the base for a
maketable query?
 
Top