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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Deleting records from a table
Thank you both for responding to my post.
I ended up using Kevin's method, and it worked just fine. Alan "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 |
#5
|
|||
|
|||
Deleting records from a table
Thank you both for responding to my post.
I ended up using Kevin's method, and it worked just fine. Alan "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 |
Thread Tools | |
Display Modes | |
|
|