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]
