Remove duplicates records

[okl]

Hi,

I have a table with 3 column : cntr , Vsl, voy

These 3 columns contain duplicate records , how can I have a query to delete the records where cntr , Vsl and voy are match?

Thanks

 

[okl]

Hi,

I have a table with 3 column : cntr , Vsl, voy

These 3 columns contain duplicate records , how can I have a query to delete the records where cntr , Vsl and voy are match?

Thanks

Leaving just the first row record .

 

[RichardMGreen]

Try creating a new table with a compound key on it.
Then run an append query from your current to table to the new one.
It will only allow the first record to be inserted as other records would create duplicates which are not allowed.

 

[SydneyGeek]

If you have a unique key you can use this technique.

Denis