breilly192
Technical User
I'm attempting to use a UNION query to make a table, but keep getting error msg that "An action query cannot be used as a row source.
The code works in Rapid Sql against Oracle tables, but when trying to use it in an Access query's sql it won't work. Tried mimicking other make-table statements that were created by Access but it doesn't like that either with UNION.
The union query will work in Access when not trying to make a table.
Can Union queries be used as make-table queries in Access?
The code works in Rapid Sql against Oracle tables, but when trying to use it in an Access query's sql it won't work. Tried mimicking other make-table statements that were created by Access but it doesn't like that either with UNION.
The union query will work in Access when not trying to make a table.
Can Union queries be used as make-table queries in Access?