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:
Please help.
If there are more than one students on leave then it only displays name of one of the students. screen shot attached.=IIf([Current Status]="Leave",[CNAME],Null)
Please help.