How to comparing two table with same field names using a query

[Bill Newport Beach]

I have both an old copy and new copy of my MS Outlook contacts imported into two Access tables (OldContacts and NewContacts). The fields in both tables are identical. I'm missing 50 records in the NewContacts table. By using a query how can I determine which records are missing?



Thanks in advance for any ideas,
Bill

[recyan]

Have you tried using The Unmatched Query?

Thanks

[Bill Newport Beach]

Have you tried using The Unmatched Query?

Thanks

Will try! Many thanks