Query Duplicates- Access 2003

[MyOwnBoss]

I have about 52k of records with duplicates.

It is a list of names with SSN. Where there are two names with the same SSN and name, one my have a middle initial and one without one, or any combination with the Initial. I would prefer the one that does have the Initial, but then also get one of the duplicates that does not have this criteria to consider for the next record comparison.

 

[jdraw]

Is this a one time fix up, or something that will happen again?
Do you have any other info that could help identify/distinguish an individual?
Can you tell us more about the application, and what you have tried?
What exactly is the problem you are having etc?

 

[MyOwnBoss]

This is a one time fix up.

I have compiled Archive Betreive DBs (several) and now need all distinct records to import into another application.

As far as any other columns we can rely on to better filter them out is random.