this query displays serial numbers from TableCopy if match serial numbers from Table2-
problem: if serial number inputed 2 or more times-
Matches increase the number of records in Table2 and displays duplicate matches
is there a way it only matches one time- if same number inputed again- it does not display?
the data type is text- because- their will be letters in serial numbers-
SELECT Table2.[serial number] AS SerialNumber, TableCopy.[serial number] AS ScannedSerialNumber
FROM Table2 LEFT JOIN TableCopy ON Table2.[serial number]=TableCopy.[serial number];