Query help

[JAYLO]

All,
I have 2 tables that have 2 fields in common. The fields are Admit Date and Record Number.
I'm trying to isolate the records that don't match in either of the tables.
One table has 93804 record and the other has 93799
Any help is appreciated.

 

[SydneyGeek]

Build a query using the Unmatched Query Wizard. That should show you the unmatched ones.
If you need to merge the tables and get a unique set, a UNION query will create the list for you -- check the online help. You can then base a MAKE-TABLE query on the UNION query to create a new table.

Denis