Hi Doug. Good to hear from you in this neck of the woods. :-)
By default, a UNION query will de-duplicate.
To get all records, use UNION ALL, e.g.
SELECT * FROM Table1
SELECT * FROM Table2;
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.