Delete a Duplicate Query from main table



I have a table with 66,180 mailing addresses and I did the duplicate query
and it found 3288 duplicates. I tried to do the delete query to delete the
duplicae query from the main table but can not get it to work. Any advise or
help would be much appreciated. The addresses include first name, last name,
st. address, city, st. I'm just so frustrated!! Thanks in advance!

John Spencer MVP

Do your records have a primary key? A value that is unique to each record and
is not duplicated?

Perhaps you can post the SQL of the duplicate query? (Menu: View: SQL).

I assume you want to keep one of the duplicated records.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County


Thank you for the response. No I do not have a primary key. I do want to
keep one of the duplicate records. I will try doing the SQL and see if I can
get somthing that way.

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