I know I can search for duplicate records in Access, and I am aware of the so-so query that exists. Here is my dilema.
I am trying to ensure that duplicate names do not exist in a seperate database (seperate from Access, it's an old database that does not have a lot of access to it). I have the ability to download the entire file into Access and then I can search for dupliactes. What I want is a mechanism to let me know those that have already been determined to NOT be duplicates.
Here is the example. There are two John Smith's in the database when I download it today. I review the records and know they are unique records and should not be considered duplicates. How can I flag these two records not to show as duplicates of each other, but still be avaiable for matches for new John Smith's should one be in the next download?
Also, I won't be saving (although I can) the prior download, so this will run in to a lot of work. There are close to 100,000 records to review.
Any tips are appreciated. _____________
Cliff
I am trying to ensure that duplicate names do not exist in a seperate database (seperate from Access, it's an old database that does not have a lot of access to it). I have the ability to download the entire file into Access and then I can search for dupliactes. What I want is a mechanism to let me know those that have already been determined to NOT be duplicates.
Here is the example. There are two John Smith's in the database when I download it today. I review the records and know they are unique records and should not be considered duplicates. How can I flag these two records not to show as duplicates of each other, but still be avaiable for matches for new John Smith's should one be in the next download?
Also, I won't be saving (although I can) the prior download, so this will run in to a lot of work. There are close to 100,000 records to review.
Any tips are appreciated. _____________
Cliff
