Looping(?) to get Unique Result

[tonere]

I have a table (NSCH) that contains two fields, Id and College which tracks the colleges (College) attended by students (Id) and may contain multiple records for each unique Id. I would like to output a table that has two (2) fields, a single record for each Id and a field that concatenates all the colleges.

NSCH looks like this:

200100 UNC
800500 UVA
800500 VT



I would like the output to look like this

200100 UNC
800500 UVA, VT

I have looked at many looping examples but do not understand, is there an easier way to get the result?

Thank you in advance for helping!

[orange]

see
https://www.accessforums.net/access/...html#post88581

[tonere]

After hours of copying, pasting and editing, I got it.

I had a lot of trouble with the third argument.

Thank you so much for the reference to Allen Brownes solution.

[orange]

Glad you got it working. I think we should both thank Allen Browne.