Delete duplicate records

  • Thread starter Thread starter Zanetti via AccessMonster.com
  • Start date Start date
Z

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?
 
Hi all,
I have problem to delete duplicate records from one table .
Does anyone have idea how can i do that?
Click to expand...

The big question should be: Why are there duplicate records in the
first place?
 
Hi all,
I have problem to delete duplicate records from one table .
Does anyone have idea how can i do that?
Click to expand...

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]
 
Back
Top