Comparing similar tables

[Kaz]

Hi

I have two tables one kept updated by me and another by an
outside source. The fields in then are the same
(Destination, Method of Delivery and Time).They should
have the same information but unfortuately they do not.
How do I find out what records appear in only one table
and which table that is. And then create a new table with
all the records that appear in both tables.

Thanks in advance

Kaz

 

[[MVP] S. Clark]

Try using the Unmatched Query Wizard.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-