Another Dupe Records Question

M

Microsoft

Greetings,

I need to delete over 16,000 duplicate records in 3 tables. I used the
following SQL for the four fields that make up the dupes I am after:

Select Distinct FN, LN, ADD1, CTY From tblDonor01

When I preview the query, it appears to have removed the dupes. I go from
47,000 records to about 38,000 records. But, the tables each have 17
fields. The above only works for the 4 dupe fields. I need to add 13 other
fields that are not used for calculating dupes. I assume I should run a
make table query and create a new table without the dupes?

Best regards,
Scott B
 

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

prevend dupes if 4
Multi-field primary key, no dupes - but only if one field is empty? 7
Testing if a query has a result 1
Dupes in one column in table - is this possible?? 5
query that doesn't select dupes 2
check for two fields instead of one 4
Duplicate Record Mess 6
Customer DB Duplicates 3

Top