Bevos
asked on
Access 2007: SQL question, compare two fields and report which values are not repeated
Hello, I would like to make a simple query in SQL that shows me which values for a field are not contained within both fields. I have a table (tblRecordNumbers) with RecordNumberOld and RecordNumberNew fields. Record number old has 675 entries and RecordNumberNew has 941. I need to know what numbers in RecordNumberNew are not in record number old. Can anyone please explain how to do this?
Thanks,
Bevos
Thanks,
Bevos
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks so much Capricorn1, this works exaclty as intended.
Bevo
Bevo
SELECT tblRecordNumbers.RecordNum
FROM tblRecordNumbers LEFT JOIN tblRecordNumbers AS tblRecordNumbers_1 ON tblRecordNumbers.RecordNum
WHERE (((tblRecordNumbers_1.Reco