Footer in Forms

[miacino]

I have a list of providers in a form pulled from a query of records.
i.e.,
1 Smith
2 Jones
3 Lina

I want a field in the footer to read these in a text box as "Smith, Jones, Lina". Not sure how to do this with text. I know with #'s I could do a count or sum function. Not sure if there is a function for text. Haven't gotten into the VB coding side of access yet!
Any suggestions?

 

[miacino]

Hey there Uncle Gizmo,
Thank you for your help. That formula didn't seem to work for me!
See attachement - maybe I wasn't clear on what I'm trying to do in my report.
Thanks for any offered help!


Michele