Combine Mailing List

[Guest]

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

 

[pietlinden]

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...

 

[Guest]

Thx!

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...