Cross checking two sources

[Jennifer]

I have a spreadsheet that is being sent to me weekly with managers that are
out on leave. I have a table that we keep track of on our own.

I need to know if it is possible to set a query that will show unmatched
records from BOTH sources. Neither source is absolutely correct.

Thanks!

 

[KARL DEWEY]

How many fields are to be checked? Post table structure.

 

[Jeff Boyce]

Jennifer

"How" depends on "what" ... if you don't tell us what data you have, we can
only guess how to do this...

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jennifer]

HRID is the common field.

Then I only need first name, last name, Division and District

 

[Jennifer]

Both tables have the same data.

HRID, Manager name, Division and District.

HR keeps track of one source and we keep track of another. Some managers
communicate to HR and some to us so we need to find out who is not on BOTH
records so we can update each file. I tried the unmatched query but that
assumes one record is correct.

HRID is the common field.

 

[KARL DEWEY]

Try this --
SELECT Table1.HRID, Table1.[Manager name], Table1.Division, Table1.District
FROM Table1 LEFT JOIN Table2 ON Table1.HRID = Table2.HRID
WHERE (((Table2.HRID) Is Null))
UNION ALL SELECT Table2.HRID, Table2.[Manager name], Table2.Division,
Table2.District
FROM Table2 LEFT JOIN Table1 ON Table2.HRID = Table1.HRID
WHERE (((Table1.HRID) Is Null));