Group in a horizontal line separated by commas

[Ellen]

Hello,
I'd like to group data in a horizontal line separated by commas. For
instance,
Let's say we have two fields, category and item. I'd like the report to
look as such:

category 1
item 1, item 2, item3

category 2
item 4

category 3
item 5, item 6, item 7, item 8

Thanks in advance for your help!
Ellen

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Ellen]

Thanks, Duane. I'll give your function a try.

Have a good day!!!!