print labels/omiting duplicate addresses

[Bradu]

Please help...

I need to print labels from a large mailing list. If two
people live at the same house, I only want to send them
one item. So, how can I run a query- telling it to not
display duplicate records, where only the street address
match

Thank you.

 

[Jeff Boyce]

Bradu

If you create a query that lists "DISTINCT" addresses, you'll have most of
the problem solved. The next step is to join those addresses back to the
people who "own" them -- here's the next problem:

What do you want to do when there is more than one person sharing a
distinct address? Show both names? Show ALL names (could there be more
than two?)?

And are you quite certain that your people and addresses are entered
identically? For example, are the following addresses (and people)
identical:

J. Jones 12345 Elm St.
John Jones 12345 Elm Street
J.J. Jones 12345 Elm St. SW
John Jones 12354 Elm Street

It may be a bit more complicated than you'd originally thought!

Good luck

Jeff Boyce
<Access MVP>