Delete a Duplicate Query from main table

[TGrin]

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

 

[TGrin]

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.