Delete many dublicate records from one table

G

Guest

I have a table with 1600 records. Almost every record in the table is
duplicated two to four times within the table. I want to just find one each
of the unique records. The field that will identify the unique record is
Rec_Ident. I can get a table with all of the dups or I can get a table with
all of the dups and their occurance but I can't get one that shows the entire
record just once. Any help? Thanks!
 
G

Guest

You can create a query that will return only one record if all the fields
between the records are equal, just add to the select query Dstinct and try it

Select Distinct TableName.* From TableName
 

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

Similar Threads

Access Query - "Duplicate Records Selected" 5
Delete dups in a table 3
Create a distinct Join 3
Delete all but first dup 1
Populate Table with Fields from Another Table? 6
Populate Table with Fields from Another Table 1
Querry to get unique records from 3
Deleting Duplicate Records, Keeping First Occurance 3

Top