Delete a Duplicate Query from main table

  • Thread starter Thread starter TGrin
  • Start date Start date
T

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!
 
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.
 
Back
Top