Delete duplicate records

[Zanetti via AccessMonster.com]

Hi all,
I have problem to delete duplicate records from one table .
Does anyone have idea how can i do that?

 

[Bob Hairgrove]

Hi all,
I have problem to delete duplicate records from one table .
Does anyone have idea how can i do that?

The big question should be: Why are there duplicate records in the
first place?

 

[John W. Vinson]

Hi all,
I have problem to delete duplicate records from one table .
Does anyone have idea how can i do that?

Several ways, depending on the structure of the table, whether it's a one-time
or an ongoing issue, size of the table, who'll be running the operation...

As Bob says, it's best to prevent duplicates from the start (by proper choice
of unique Indexes and/or code in the BeforeUpdate event of your Form). It's
certainly possible to run a Delete Query, or create a new table with unique
indexes and append the data into it. Please post some more details!

John W. Vinson [MVP]