Take Out Duplicates

[Micah]

Hi - I need to remove all the duplications in a table. I have 49000 records and need to do some trimming! The field name is "place".

I have run the duplicate wizard but that just shows me the duplicates without taking them out of the table

Any ideas?

ps - I'm a newbie so please go easy!

 

[jon98548]

Search Access for 'delete duplicate records'. It lays it out real nice.

 

[Pat Hartman]

The simplest way to "delete" duplicates is to create a new table that includes a primary key that will prevent duplicates from being added. You then append your old table data to the new table and ignore the error that x records were not added due to key violations. Any other error should be dealt with.

 

[Rich_Lovina]

Taking Out Duplicates, and Updating one field

In my duplicates, my query compares 4 fields before selecting the duplicate set. In 2 of the 4 fields I have old data, which I want to transfer to the kept record e.g.

Old Record: Ms, JA, Jenny, Smith, TitleX1, ABC26, 1/2/03
Later Record: , JA, ,Smith, TitleX2, ABC26, 1/10/03

Before I delete OldRecord, I want to update (transfer) fields 1 and 3 data.

The duplicate set can run to 500-1,000 so short of many cut & paste, are there any other options. Familiar with basic VB.

Any help greatly appreciated.



Perth....the windiest city in the world.

 

[RichardMc]

Search Access for 'delete duplicate records'. It lays it out real nice.

I love it when I don't even have to post my question! A quick search, and the answer is already there! Thanks for blazing the trail...