Display multiple Field values in single text box in Access report

imrrs

New member
Local time
Today, 07:17
Joined
May 14, 2022
Messages
1
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.
02.JPG
01.JPG
 
Hi. Welcome to AWF!

Try moving your Textbox in the Details section.
 

Users who are viewing this thread

Back
Top Bottom