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?