I have a report that if the value of a boolean is false it will print "Dropped", and if true will print "Attending". I had it working at one time, but will not work now.
In the caption of the label I put the following code: =IIF([Attending] = True, "Attending", "Dropped") where [Attending] is the control.
In the caption of the label I put the following code: =IIF([Attending] = True, "Attending", "Dropped") where [Attending] is the control.