2 queries, 1 recordset

[ender_pete]

i want to insert the results of 2 queries into 1 recordset
the queries have all the same fields and stuff...
i just need to know if it is possible so i don't sit here and waste time trying to get it to work.
thanks

[Lafor]

select * from tbl1
union
select * from tbl2

[paulw]

Don't forget that a UNION query is read-only. If you want to update it, create a temporary table...

Cheers,

P.

[ender_pete]

i forgot all about unions
thanks guys