Access SQL to combine two queries into one single table

[miss D]

I have run 2 queries in Access which has the same field names,

Qry1:
Mgr ID
Mgr Name

Qry2:
Mgr ID
Mgr Name

how do I combine these two queries into a single table?
Please help me with the code.

Thanks.

[Stewart Ross]

Hi. Use a union query, which you will need to type in using the SQL View mode of the query editor:

SELECT * from qry1 
UNION
SELECT * from qry2;

-Stewart