Hello,
I am unable to figure out a simple issue, I am sure someone knows this one!

So I know how to put a database field in a report so when it is called on using a parameter field, it automatically fills in the data in the text box.

That looks something like this:

"Program: {program_number}"

Where everything in quotes is my text box, the "Program:" is my text and the "{program_number}" is my database field that automatically fills in.

This function works and will always fill in the program number that fits the parameters that are called out.

However, if there are in fact two programs that fit the parameters that are called out, I would like to have both of these show up.

If I use "Program: {program_number} {program_number}" only one program number shows up twice, which makes sense for how I laid that out.

Does anyone know how to make it so if two (or more) programs fit my parameter call out, these all appear in my text box after "Program:"

I am wanting a result that would look like

"Program: PROG01  PROG02  PROG03 (etc..)

Thank you in advance for your time and knowledge!!