Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DB Design Question (2003)

    The charity we're helping currently holds volunteer info in an Excel spreadsheet. This holds information about which volunteer helped out at a particular sector on a charity walk. My wife and I are in the process of helping them move this to an Access DB.
    Because the walk starts at midnight, there are a number of families which marshall the same sector - so the spreadsheet name and address data contains example like 'Steve, Linda and Mathew' in the 'firstname' field of the name and address. While it's easy to split these into separate people to hold in the DB, the address labels report will then produce three labels, one for each of these people who all live at the same address.
    In design terms, is there
    a) a way (simple, easy!) to allow only one label to be produced for a family
    and
    can it be made to allow separate labels if required (e.g. if the family decides they are prepared to marshall at separate sectors)?
    Thanks
    Silverback
    Silverback

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DB Design Question (2003)

    Will the database be used for several charity walks, or perhaps for other events, or is it intended for this particular charity walk only?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DB Design Question (2003)

    It's intended for this particular charity walk only.
    Thanks
    Silverback
    Silverback

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DB Design Question (2003)

    If you create a table like this:

    <table border=1><td align=center>LastName</td><td align=center>FirstName</td><td align=center>Address</td><td align=center>Sector</td><td>Jones</td><td>Steve</td><td>64 Orange Grove</td><td align=right>5</td><td>Jones</td><td>Linda</td><td>64 Orange Grove</td><td align=right>5</td><td>Jones</td><td>Matthew</td><td>64 Orange Grove</td><td align=right>5</td><td>Watkins</td><td>Peter</td><td>3 Lemon Crescent</td><td align=right>8</td><td>Watkins</td><td>Anne</td><td>3 Lemon Crescent</td><td align=right>10</td></table>
    you can then create a totals query based on the table that groups by address and sector, and returns (for example) the first name within each group. In the above example, the query would return one record for the Joneses because they all marshall sector 5, but two records for the Watkins family, because they marshall two different sectors.
    If you want to concatenate the first names of all persons in a group, you can use the Concat function from the attachment to <post#=301,393>post 301,393</post#>.

Posting Permissions

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