Access VBA or SQL to find and delete duplicate records in access table

Hi,

I need help in creating a VBA or SQL to find and delete duplicate records in an access table.

Thanks

Hi,

i am using the first code but it's not working. it says Syntax error in FROM clause. Below is the code that I have now. Thanks

Please Login or Register  to view this content.

Originally Posted by JieJenn

To delete duplicate record you can probably do

Please Login or Register  to view this content.

OR you can use Insert Into to create a unique list table.

Please Login or Register  to view this content.

so FieldX is the name of my column too?

I tried to run this but it says "Could not delete from specified tables."

Please Login or Register  to view this content.

I wish I could but i'd rather not do that

I got this error when I tried to run the code: "Error 3306. You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field."

Originally Posted by JieJenn

Can you post a sample database. It might be easier that way.