[AccessD] Find Number of Separate Addresses - DONE!

Tina Norris Fields tinanfields at torchlake.com
Tue Apr 29 11:07:23 CDT 2008


Thanks to everyone who responded and gave me inspiration.  What I did 
was to make a query that had only the address info in it - no names at 
all - and take the unique values.  This gave me a recordset of 3,209 
addresses, more than enough for my purpose.  I prepared  my mail-merge 
document with "The Registered Voters at:" as the first line of the 
mailing address, and just added the address fields for merging.  I now 
have my 2,000 postcards to mail out in support of the school board 
candidacy of my husband and another friend from our township. 

This mailing did not need to be random or anything else special - just a 
reminder to people to get out and vote on May 6th for two new school 
board members, and a plug for the two guys I mentioned.  Thanks again to 
everyone for helping me on this.

Tina

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



More information about the AccessD mailing list