Results 1 to 3 of 3

Thread: Report Display

  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: Report Display

    On my report I am displaying a field where the data was selected from a combo box on a form, therefore I can have more than one record for this field. When I preview the report the data is displayed in rows e.g.

    record1
    record2
    record3

    How can I have it displayed as:

    record1, record2, record3

    ????

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    If you only have the three records to display you could use something like:

    Me.txtRecords = record1 & ", " & record 2 etc

    If there are more records you may need to look at a cross tab report, which is a little complex.

  3. #3
    Join Date
    Sep 2001
    Posts
    175
    Thanks - will give it a try

Posting Permissions

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