How to delete a row if "address" matches another row in table

[Scott Hager]

I need to fine tune a mailing list that has multiple entries for individual
customers. If I can run a search to delete a row that contains an
address(column) that is the same as one in a different row, I can fix my list
very easy.

Please help.

Thanks

 

[Steve Schapel]

Scott,

For a start, you could try this... Select the Queries tab in the
Database Window, click New, then select the Find Duplicates Query
Wizard. Click Ok, and then follow the prompts. Hopefully that will do
what you need.

 

[Scott Hager]

This allows me to find the duplicates, but it does not allow me to delete
them. I need to be able to clean up the list using Access or Excel (2000)
without all of the manual work. Thanks

 

[Steve Schapel]

Scott,

Another approach might be to make a query that just returns one row for
each address. For example, this might be a Totals Query using
appropriate Group By and Max or First or whatever (just guessing here,
as I don't know what the structure of your data is). Then, make a new
table with the same fields as your existing one. And then make the
Totals Query into an Append Query, and run it to put one record for each
address into the new table. Then delete the old table. Make sense?