Hi,
I have a table with about 15,000 records in it. I need to delete all but one of each duplicate social security records. I have tried solutions in other posts on this board such as...
A. Using the find duplicates query which completely ignores half of my records when done.
B. Index the table using the SSN column, which only gives me an error telling me why I can't do it.
C. Tried running code in a module with the run code command in a macro but cannot figure out the errors that are supposedly in the code.
D. I have also tried breaking the table down into 3 smaller 5,000 record tables with little to no success.
Any help would be much appreciated, Thanks!
Thanks,
Robbie
I have a table with about 15,000 records in it. I need to delete all but one of each duplicate social security records. I have tried solutions in other posts on this board such as...
A. Using the find duplicates query which completely ignores half of my records when done.
B. Index the table using the SSN column, which only gives me an error telling me why I can't do it.
C. Tried running code in a module with the run code command in a macro but cannot figure out the errors that are supposedly in the code.
D. I have also tried breaking the table down into 3 smaller 5,000 record tables with little to no success.
Any help would be much appreciated, Thanks!
Thanks,
Robbie
