List repeating records in text, separated by commas?

[DocNice]

I want to make a report or an RTF that lists all the records in one table, and then pulls the corresponding records from another table, which may have multiple records for the corresponding master record. And I want to list them, rather than on each line, behind one another in text.

For example, instead of:
1 a I
2 b I
2 b II
2 b III
3 c I

You would have:
1 a I
2 b I, II, III
3 c I

Any ideas the best way to tackle this? If you can point my in the right direction, it would be helpful.

 

[WayneRyan]

Doc,

You're gonna need some VBA to do this. I put the VBA in a function and
called it from a query. In my example I put the related sub-records in
some number of columns, but this is similar.

http://www.access-programmers.co.uk/forums/showthread.php?t=70399

Wayne