Listing data in a row instead of a column

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
 
M

Marshall Barton

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
 
Top