Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change layout of subreport (XP)

    I have a very simple issue... but darned if I can get it to work!

    on a subreport are two fields... LegID which is not visible, it simply links the parent/child... and the field tablenumber. for each legID, there are potentially several TableNumbers. I want the format of the output of this field to be a comma'd list reading from left to right, rather than the normal list output.

    for example...

    13
    14
    9
    7
    should read as 13,14,9,7

    Thanks for any help you can give... Jenn

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

    Re: Change layout of subreport (XP)

    The attachment to <post#=301,393>post 301,393</post#> contains the code for a function named Concat that you can use to concatenate values into one long string. Copy the function into a standard module. You can then use it in expressions in queries and in the control source of text boxes on forms/reports.

    In your case, you'd put a text box in the detail section of the report with a control source like this:

    =Concat("NameOfTable","TableNumber","LegID = " & [LegID])

    where NameOfTable is the name of the table (or query) that contains LegID and TableNumber.

    Note: make sure that the text box is NOT named TableNumber, for that would confuse Access.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, USA
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change layout of subreport (XP)

    Worked like a charm! Thank you

Posting Permissions

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