View Single Post
  #3  
Old May 25th, 2010, 01:02 AM posted to microsoft.public.access
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Deleting records from a table

Alan wrote:
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


do a summary query on the address (Group by Address, City, State, Zip) and
then use FIRST for the FirstName and LastName columns.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/201005/1