Cross checking two sources

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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!
 
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
 
HRID is the common field.

Then I only need first name, last name, Division and District
 
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.
 
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));
 
Back
Top