You can also use a UNION query to bring together the 2 recordsets provided that the field names and field types are exactly the same in both recordsets.

e.g.

SELECT Field1, Field2 FROM Table1
UNION (SELECT Field1, Field2 FROM Table2);