[AccessD] Find Number of Separate Addresses

As I was thinking it over, in order to use that approach, you'd have to
include the PK of the table in the first query.  Which if you ask for unique
values means you'd get all the records instead of just one per address.  

However, if you set the PK not to show in the first query, you'd get the one
record per address and still have it available in query number two to join
to the original table.

Rocky
 


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 10:06 AM
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

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