How to concatenate subform data in a string on the main report?

[Josha]

So I currently have a database for my science students to record their examination notes.




On the 'examination' form the students fill out their case and item number and the lab room number. These all are static fields.... But then I have a related table that stores the students names... So I built a subform in to the main form where the students can record their names as well as their partners names using their initials, ABC (for example). Most of the time they work in partners but sometimes they are in groups of 3 and rarely in groups of 4.


On the main report when they print it, instead of have a subreport in the main report that lists the students initials, for example


Students
ABC
XYZ


I want the report to concatenate the students intiails like this :ABC, XYZ..... Is there a way to do this? Keeping in mind that the group of students may be 3 or 4....


Thanks!

[Josha]

I think what I am trying to say is how do I concatenate all records in a subform?

[Josha]

I was able to solve it from this website

Microsoft Access tips: Concatenate values from related records (allenbrowne.com)

[Welshgasman]

That is what I would have offered.
theDBguy has a similiar function.
http:http://www.accessmvp.com/thedbguy/codes.php/