[AccessD] Find Number of Separate Addresses

It's not allowing you to groupby those values?

Drew

-----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 12:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Find Number of Separate Addresses

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
>  
>
>   
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.