[AccessD] Find Number of Separate Addresses

Tina Norris Fields tinanfields at torchlake.com
Mon Apr 28 12:06:20 CDT 2008


Sounds good to me - I'll try that.  Thanks, Rocky
Tina

Rocky Smolin at Beach Access Software wrote:
> 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
>  
>
>   



More information about the AccessD mailing list