Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Location
    Orange Park, Florida, United Arab Emirates
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Householding (A2K/WinXP Pro)

    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.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: 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. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •