Union query syntax (Make table)

[Gates Is Antichrist]

This is #$%^#$!! . I can do a straight make-table by itself, or a select union query, but I can't do both.

select tbl1.* UNION ALL select tbl2.* into foo from tbl1,tbl2;
gives error
"Query input must contain at least one table or query"

Every rearrangement I've tried fails, such as
select * from tbl1 UNION ALL select * from tbl2 into foo;
("Syntax error in FROM clause")

Save me

 

[mdmilner]

When I first ventured forth into the world that is access, I was told something by an experienced programmer which I have yet to disprove.

SQL & VBA within Access is really a subset implementation (Half Assed was the word used) and doesn't really have all features fully implemented. I'm never surprised when I hear of complaints that seem to be in the same vein.

Me, I'd just go ahead and build them as a two step process and go from there.

Mike

 

[Gates Is Antichrist]

How would you do that? Delete query then 2 appends is the only way I can see.