First question, how do you know which ones are the "Original" records?
If they are exact duplicates, there would be no way to tell them apart.
If you want to delete all but one, then that can be done. Is this a one time
thing or will you have to do this frequently?
One time, just select all but the first record (or whichever you decide is the
"Original" and press the delete key.
Many times? Then what is the primary key for the records (that should be
unique). If you don't have a primary key, then with this limited number of
records, I would probably just use a bit of VBA to delete records.
In other words, we need more information.
By the way, 123 records that are all the same or you have 123 records returned
where there are sets of duplicates with two or more records in each set?
