Display multiple Field values in single text box in Access report (1 Viewer)

imrrs

New member
Local time
Tomorrow, 03:58
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
 

Gasman

Enthusiastic Amateur
Local time
Today, 23:58
Joined
Sep 21, 2011
Messages
10,342
Google @theDBguy simplecsv function here or Allen Browne's Concatenate
 

theDBguy

I’m here to help
Staff member
Local time
Today, 15:58
Joined
Oct 29, 2018
Messages
18,791
Hi. Welcome to AWF!

Try moving your Textbox in the Details section.
 

Users who are viewing this thread

Top Bottom