Prev: Access97 runtime
Next: Date
From: Alan on 24 May 2010 18:37
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


From: kc-mass on 24 May 2010 19:16
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" <somewhere(a)nospam.not> wrote in message
news:exqUiG5%23KHA.4472(a)TK2MSFTNGP02.phx.gbl...
> 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
>


From: PieterLinden via AccessMonster.com on 24 May 2010 20:02
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/Forums.aspx/access/201005/1

From: Alan on 27 May 2010 12:32
Thank you both for responding to my post.

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

Alan

"Alan" <somewhere(a)nospam.not> wrote in message
news:exqUiG5%23KHA.4472(a)TK2MSFTNGP02.phx.gbl...
> 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
>


From: Alan on 6 Jun 2010 09:34
Thank you both for responding to my post.

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

Alan

"Alan" <somewhere(a)nospam.not> wrote in message
news:exqUiG5%23KHA.4472(a)TK2MSFTNGP02.phx.gbl...
> 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
>


 | 
Pages: 1
Prev: Access97 runtime
Next: Date