Union query with maketable

M

m miller

Hi all,

I am a MSAccess newbie, I usually work with .NET, SQLServer, Oracle, etc.

I'm trying to create a maketable query that uses UNION syntax and MSAccess
doesn't seem to like
any of my variations and gives me the error:

'An action query cannot be used as a row source.'


Here are my syntax:

select * INTO TEST4
FROM TEST

UNION SELECT * FROM TEST2

UNION SELECT * FROM TEST3

What would the MSAccess syntax be? This works in SQLServer, Oracle and
Foxpro.

TIA,
Marc Miller
 
P

Pieter Wijnen

create a union query & use that as the source, is one solution
(i didn't know oracle supported select .. into ;-))

hth

pieter
 
M

m miller

Pieter,

Thanks, I would never have thought of it.
(btw, your right Oracle insists on being burdensome with create table and
insert into).

Marc Miller
 
J

John Vinson

What would the MSAccess syntax be?
Click to expand...

Create and save a UNION SELECT query, and then base the action query
on *this* query:

1. Save

SELECT * From TableA
UNION
SELECT * From TableB
UNION
SELECT * Form TableC

as uniABC;

2.

INSERT INTO TableX
SELECT * FROM uniABC;
 
Top