Access Mailing list problems

[Guest]

I am trying to create a mailing list from a county tax roll. I have a table
with the following fields:

PPIN(unique parcel number), OWNER (name of owner), C/O (mailing
instructions), ADDRESS, CITY, STATE, ZIP, SECTION, TOWNSHIP, RANGE,
CULTIVATABLE ACRES, UNCULTIVATABLE ACRES, TOTAL ACRES

I want to create a mailing list from the data for each address that owns
more than 100 uncultivatalbe acres in aggregate. Since an owner may own
multiple parcels I want to sum the total acres each person/or address owns.

The problems are:

1. I would delete duplicate records for OWNER but many parcels owned by the
same person may or maynot in include a spouse on some records so they aren't
all exactly the same.
2. I would delete duplicate records for ADDRESS that there are duplicate PO
Boxs numbers, but they are in different towns.

Any help would be appreciated.

 

[Larry Daugherty]

#1 Just the fact that there is a spouse doesn't always mean joint
ownership in the real estate.

#2 Look for help on Find Duplicates. You want to deduplicate those
records where both the town and PO Box are the same.

HTH