Insert Into Union query

[Deutz]

Hi and thanks in advance,

I am using Access 2003.

I am trying to formulate SQL for an INSERT INTO query that UNIONS 6 queries into the table ... but without success.

This is what I have so far, any idea where I am going wrong?

INSERT into Revenue
SELECT * FROM qryRevenue1


UNION ALL
SELECT * FROM qryRevenue2
UNION ALL
SELECT * FROM qryRevenue3
UNION ALL
SELECT * FROM qryRevenue4
UNION ALL
SELECT * FROM qryRevenue5
UNION ALL
SELECT * FROM qryRevenue6



Thanks
Deutz

[RuralGuy]

Union queries are by definition not updateable.

[Deutz]

Thanks RuralGuy

Looks like it will just have to be a two step process.

[RuralGuy]

Here's a good reference link for queries: http://allenbrowne.com/ser-61.html

[Deutz]

Thanks, I'll take a look at it