Here is the SQL of the query:
Code:
INSERT INTO [RetailersActive] ( Tradename, City, StreetAddress, License, SmallUBI, [SuiteRm], State, County, ZipCode, PrivDesc, PrivilegeStatus, DateCreated, DayPhone )
SELECT tblAddRetailers.Tradename, tblAddRetailers.City, tblAddRetailers.StreetAddress, tblAddRetailers.License, tblAddRetailers.SmallUBI, tblAddRetailers.SuiteRm, tblAddRetailers.State, tblAddRetailers.County, tblAddRetailers.ZipCode, tblAddRetailers.PrivDesc, tblAddRetailers.PrivilegeStatus, tblAddRetailers.DateCreated, tblAddRetailers.DayPhone
FROM tblAddRetailers
WHERE ((([Tradename] & [City] & [StreetAddress] & [License] & [SmallUBI]) Not In (SELECT [Tradename] & [City] & [StreetAddress] & [License] & [SmallUBI] FROM [RetailersActive])));
When viewing the records, it selects the correct ones so it seems to work fine there.