Listing data in a row instead of a column

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

How do you show data in a report across the page in a row
instead of a column? I have a set of machine types in a
table that I want to show in paragraph format with each
machine type seperated by a comma. Essentially, I want
the report to look like the example below. Thank you for
your help.

Grouping 1:
machine A, machine B, machine C

Grouping 2:
machine D, machine E, machine F, machine G, machine H

Grouping 3:
machine I, machine J
 
Jon said:
How do you show data in a report across the page in a row
instead of a column? I have a set of machine types in a
table that I want to show in paragraph format with each
machine type seperated by a comma. Essentially, I want
the report to look like the example below. Thank you for
your help.

Grouping 1:
machine A, machine B, machine C

Grouping 2:
machine D, machine E, machine F, machine G, machine H

Grouping 3:
machine I, machine J
Click to expand...


You need to create a function to build the list from related
records in a table/query. Here's a function that you can
use:
http://www.mvps.org/access/modules/mdl0004.htm
 
Back
Top