Display multiple Field values in single text box in Access report

[imrrs]

I am trying to display names of students who are on leave in front of class strength. I am using the following statement in Textbox:

=IIf([Current Status]="Leave",[CNAME],Null)

If there are more than one students on leave then it only displays name of one of the students. screen shot attached.
Please help.

 

[Gasman]

Google @theDBguy simplecsv function here or Allen Browne's Concatenate

 

[theDBguy]

Hi. Welcome to AWF!

Try moving your Textbox in the Details section.