[AccessD] Find Number of Separate Addresses

Maybe two queries - one with just the address fields and Unique Values set
to True so you get only one per household.   Then a second query with the
first query linked to the original table via PK/FK with the additional
fields you need?



Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Monday, April 28, 2008 9:02 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Find Number of Separate Addresses

Hi All,

I'm thinking this should be easy, but I'm not getting it.  I have a table of
registered voters.  I want to send a postcard to each household in this
table, not to each individual. 

The addresses have these address fields:
PrefixHouseNum - there aren't any in this table, but the fields come from my
state's qualified voters list, so. . .
HouseNumber
SuffixHouseNum
PrefixDirection - pre-directional for WayName, S, E, W, or N WayName WayType
- such as St, Rd, Ave, Blvd, and so fort SuffixDirection - post-directional,
as in my address 5860 Aarwood Rd NW ResExtension - apartment numbers and the
like City State Zip

There are 6329 registered voters in the local school district, many of whom
are married couples or other family arrangements.  I want to send one
postcard to a household.  It seems it should be simple for me to find unique
combinations of HouseNumber, SuffixHouseNum, ResExtension, PrefixDirection,
WayName, WayType, and SuffixDirection, but, doggone it, I am not seeing how
to do that. 

Please help me think my way through this.

Thanks,
Tina
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.5/1400 - Release Date: 4/27/2008
9:39 AM