Working with a large (70Mb) databases that list individuals by name and street address. Would like to create a table for mailing that lists a single name, ie., The (name) family and the address. Any suggestions.
Results 1 to 3 of 3
Thread: Householding (A2K/WinXP Pro)
-
New Lounger
- Join Date
- Aug 2002
- Location
- Orange Park, Florida, United Arab Emirates
- Posts
- 11
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-09-04 17:33Householding (A2K/WinXP Pro)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Gold Lounger
- Join Date
- Jun 2001
- Location
- Crystal Beach, FL, Florida, USA
- Posts
- 3,306
- Thanks
- 1
- Thanked 11 Times in 11 Posts
2002-09-04 18:25Re: Householding (A2K/WinXP Pro)
Your wrote:
>>Working with a large (70Mb) databases that list individuals by name and street address. Would like to create a table for mailing that lists a single name, ie., The (name) family and the address. Any suggestions<<
In Access (and indeed all relational databases), you don't create tables just to rearrange the existing data. You use queries to do that.Mark Liquorman
See my website for Tips & Downloads and for my Liquorman Utilities.
-
3 Star Lounger
- Join Date
- Jan 2001
- Location
- Edmonton, Alberta, Canada
- Posts
- 326
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2002-09-04 20:19Re: Householding (A2K/WinXP Pro)
I'm not sure I understand your question about listing a single name, but if I'm interpreting your question correctly, you'll probably want to use a summary query (click the summation symbol in the query design grid) to get one occurence of each last name/address combination. However, you may run into problems unless you've been extremely consistent about how you entered the addresses.
