Query Delete Duplicates

  • Thread starter Thread starter Royce Schnepp
  • Start date Start date
R

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?
 
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?
Click to expand...

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?
 
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.
 
Back
Top