update

[dcarr]

I want to create a query that deletes duplicate rows from a tables. I have created a find duplicate query that finds the duplicates based on a value but I want to turn this into a delete query. I tried to write a delete query that deletes the field where the count is greater than one, but this does not work? Any ideas as to how I should build the query?

 

[Rich]

Just change the query to a delete query from the toolbar

 

[dcarr]

Doesnt work doing this. has 0 rows to update

 

[MattS]

Check out this thread - here