Query Delete Duplicates

[Royce Schnepp]

I am trying to delete duplicate imported records in a table. I have done the
find duplicate query wizard. But what I am trying to do is make a Delete
Query that will go through the table and delete duplicate records.

How do I do this?

 

[Michael Gramelspacher]

I am trying to delete duplicate imported records in a table. I have done the
find duplicate query wizard. But what I am trying to do is make a Delete
Query that will go through the table and delete duplicate records.

How do I do this?

Is there a unique key on each row? (better if there is)

What columns taken together make the row unique?

What is the name of the table?

 

[Royce Schnepp]

There is no primary key, because some data is left blank. It's a foreclosure
data base. So if I set a key it leaves information out. What I am trying to
do is have it go through the database and based on T_S_NO column, select all
the duplicates and erase them from table TDS_MASTER.