Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    Anaheim, California, USA
    Posts
    556
    Thanks
    17
    Thanked 2 Times in 2 Posts

    2002/SR1 (Combining Names)

    I know I have seen this one before and did a search but now sure what to search on, so I couldn't find it. I have a student database, with a Family Table and Student Table, the family is a one to many for the students. What I do now when I send out a letter is address it to "The Students at" so & so Family. What I would like to do is to send it to Joe, Jane and Bill So & So. How do I combine the names for each family? Thanks for the help.

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

    Re: 2002/SR1 (Combining Names)

    See <post#=301393>post 301393</post#> for a custom concatenation function Concat that can be used to assemble a string of the form "Joe, Jane, Bill". If you really want "Joe, Jane and Bill", it becomes more complicated.

Posting Permissions

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