Can I delete rows that have the same address in the address field.

[Guest]

I have a large data base. I want to delete every entry where the address
field is a duplicate. The other data, such as name, is different. Can this
be done?

 

[John Vinson]

I have a large data base. I want to delete every entry where the address
field is a duplicate. The other data, such as name, is different. Can this
be done?

Probably the easiest way is to create a new, empty table by copying
and pasting the current table, design mode only, to a new table. Open
this new table in design mode and use the Indexes icon (looks like
lightning hitting a datasheet) to create a unique Index on the address
field (or fields).

You can then run an Append query appending the data form your current
table into this new one. You'll get a warning message "xxx records
were not added due to index violations" - these are the duplicates. If
you agree to run it anyway, you'll now have a new table with an
arbitrary record for each address.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps