Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Location
    Fort Worth, TX
    Posts
    43

    Unanswered: Show multiple records as a single line on report

    I am wondering if it is possible to have a report display multiple records as a single row of text with commas between each record.

    In other words, I have a dbase that has multiple container numbers under a single shipment number. I would like to have the ctrs numbers show as a single record

    example
    Shipment#
    Ctr 1
    Ctr 2

    Report
    Shipment# Ctr1, Ctr2

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Paul

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Another approach that I have used in the past is to create a subreport with columns. If you have never worked with columns the settings are in the Page Setup of the report. The columns will allow you to present the data with a little more control of the formatting.

Posting Permissions

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