G
Guest
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
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