Delete duplicate rows

[krishnarao]

I have only one text column field in a table. I want to delete duplicate records i.e., if it has duplicate value, it should leave first record and delete the rest of the records.

Is there any row number concept in Access??

Pls advice. Thanks in Advance.

 

[MSAccessRookie]

I have only one text column field in a table. I want to delete duplicate records i.e., if it has duplicate value, it should leave first record and delete the rest of the records.

Is there any row number concept in Access??

Pls advice. Thanks in Advance.

Do you need to delete them, or would it be enough to ignore them? You can ignore them by doing something like this:

Select DISTINCT TheField FROM TheTable
​

 

[krishnarao]

No i want to delete the records!

 

[Rabbie]

The simplest way is to base a Maketable query on the query given by AccessRookie. then delete the original table and rename the new table.

 

[krishnarao]

Great! it worked for me...
Thanks

 

[Rabbie]

Happy to have been of help