Access Repeats

[wrestlingmjn59]

So I have thousands of lines of contact information. I need to delete all of the repeating contacts. Is there a way to do this? Is there a filter or querry specifically for this?

 

[Remou]

Have you seen:
Delete Duplicates (Save One From Each Group)
faq701-5721

 

[cranebill]

Or create a new table of distinct records....

delete records from old table

insert data from new table to old table

 

[wrestlingmjn59]

OK I tried what Remou said and I can't seem to get the code right. I put in Sheet1 as the table name code but I'm not exactly sure what should go in as ID or DF. Could someone direct me a little more with this please?

 

[PHV]

Copy your actual table (structure only)
Open the copy in table design view, multiselect the fields you want to dedup (eg FirstName, LastName) and make them an unique index (ie not allowing duplicate)
Save and go in datasheet view
Open the original table and copy all records in the clipboard
Return to the copy and paste-append

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

are you using Excel? (Sheet1?)

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi