View Single Post
  #2  
Old May 25th, 2010, 12:16 AM posted to microsoft.public.access
Kc-Mass
external usenet poster
 
Posts: 362
Default Deleting records from a table

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" wrote in message
...
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