Query Delete Duplicates


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?
 
Ad

Advertisements

M

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?
 
Ad

Advertisements

R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top