If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Deleting records from a table
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 |
Thread Tools | |
Display Modes | |
|
|