XXX Action Query XXX

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
Did you try saving your union query and then using it as the base for a
maketable query?
 
Back
Top