I'm creating a mailing list generated by APN numbers/land ownership. Many
property owners own several parcels. How can I combine the files so only one
mailing address is used?

Fields are as follows:
ID
APN #
Owner
Mailing Address
City
Zip

thx

On Jul 10, 4:40 pm, MB <M...@discussions.microsoft.com> wrote:
> I'm creating a mailing list generated by APN numbers/land ownership. Many
> property owners own several parcels. How can I combine the files so only one
> mailing address is used?
>
> Fields are as follows:
> ID
> APN #
> Owner
> Mailing Address
> City
> Zip
>
> thx

You would have to remove the TractID or whatever identifies the piece
of land, and then you could use a distinct query.

SELECT DISTINCT Owner, [Mailing Address], City, Zip
FROM SomeTable
ORDER BY...

Thx!

"(E-Mail Removed)" wrote:

> On Jul 10, 4:40 pm, MB <M...@discussions.microsoft.com> wrote:
> > I'm creating a mailing list generated by APN numbers/land ownership. Many
> > property owners own several parcels. How can I combine the files so only one
> > mailing address is used?
> >
> > Fields are as follows:
> > ID
> > APN #
> > Owner
> > Mailing Address
> > City
> > Zip
> >
> > thx
>
> You would have to remove the TractID or whatever identifies the piece
> of land, and then you could use a distinct query.
>
> SELECT DISTINCT Owner, [Mailing Address], City, Zip
> FROM SomeTable
> ORDER BY...
>
>
>