Deleting records from a table

[Alan]

Hi all,

It's amazing just how quickly -- or maybe the four years since I retired
from developing databases isn't that 'quickly' after all :-> -- that I could
forget how to do something that should really be easy.

I have a table with a couple of thousand records. Each record contains a
field for first name, last name, street address, city, state and zip. There
can be four or five people at one address, and there is a record for each of
them.

I need to cull down the amount of records so that only ONE name at each
household will get a mailing.

I remember that I used to be able to do this by running a make table,
delete, append....or some other sort of query -- and it wasn't too
complicated.

Will someone be kind enough to refresh this 'older' gentleman's memory how
it's done?

Thanks so much.

Alan

 

[kc-mass]

You could copy your table (structure only) to a new table; set a compound
index on street address, city, state and zip with no duplicates allowed.
Then simply append your records to the new table. Only one of each address
will get in.

Regards

Kevin

 

[Alan]

Thank you both for responding to my post.

I ended up using Kevin's method, and it worked just fine.

Alan

 

[Alan]

Thank you both for responding to my post.

I ended up using Kevin's method, and it worked just fine.

Alan