Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    13

    Exclamation Unanswered: Create a field joining values from multiple records

    I have a report where I need to list the serial numbers for a given order line. There could be multiple serial numbers per line. I want to show these serial numbers in one field delimited by a comma.

    This is what I have:

    318136
    318137
    318138
    318160

    This is what I want:

    318136, 318137, 318138, 318160

    How do I do this? I think I am overthinking the problem ....... Please help.

  2. #2
    Join Date
    Feb 2009
    Posts
    10
    Quote Originally Posted by jmt
    I have a report where I need to list the serial numbers for a given order line. There could be multiple serial numbers per line. I want to show these serial numbers in one field delimited by a comma.

    This is what I have:

    318136
    318137
    318138
    318160

    This is what I want:

    318136, 318137, 318138, 318160

    How do I do this? I think I am overthinking the problem ....... Please help.
    First, I would create this kind of formula (I use the BASIC language):

    If notonlastrecord then
    totext(serial_number) & ", "
    else
    totext(serial_number)
    endif


    Then in the detail section expert click on the "underlay following section"...

    Hope this helps and I don't steer you the wrong way.

    David

Posting Permissions

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