Moving Duplicate Records

T

Tracy McClarnon

Hello,

I have been assigned the task of moving duplicate records from one table to
another table exactly like it. There are three fields that I am using to
determine if they are duplicates: Field1, Field2, and Field 3. I must leave
at least one unique record in the original table. Any suggesstions?

Our table has reached its limit and will not allow us to add anymore
(Currently about 1.8 million records). It's Access 97 by the way. If that
helps.

Thank You,

Tracy
 
T

Tracy McClarnon

Gary,

Your idea works great. Now I have a new table with all unique values in it.
How do I delete the old table and rename the new one?

Thank you,

Tracy McClarnon
 
T

Tracy McClarnon

Test

Gary Walter said:
just to be clear, the *one index* is on all 3 fields together


select the 3 fields (hold down CTRL key and
click on each field), then click on primary key icon
in toolbar
Click to expand...
 
T

Tracy McClarnon

That owrked great! Now how do I delete the old table and rename the new one?
 
Top