Delete duplicate record

J

Jeff

Hi,

I have a table with 10,000 rows and 10 columns.

Column 1 has text values, I want to delete the record if they have a
duplicate, that is delete all the records.

So if Column 1 has a two, three, four,... rows with the same value I would
delete
ALL the two, three, four... rows.

I have a query that finds the duplicate, but how do you delete this?

Thanks for your help on this
 
J

Jae

Dear Jeff,

You could create an exact same table structure without any records. In that
new table make the column 1 the primary key. Then append the table.
 
J

Jae

I just read what I wrote and it didn't make sense. Let me rephrase what I
wrote. Create a new table with exact same table structure. Make column 1 a
primary key then append all the records.
 
Top