Thanks so much for your help. I have the working query below. My only concern is that it might be possible someone left spaces in a name, before or after.

Form your initial insertion query, such as "INSERT INTO your_table (column1,column2) VALUES ('1','a');" Alter the query by adding a rule for what to do if a duplicate key is found, such as "INSERT ...

The Find Duplicates Query wizard handles this chore quickly and easily. When maintaining an Access database, it’s a good idea to regularly remove duplicate records.