I have a report that groups equipment by employee. If the checkbox field [OffCampus] is checked, I want an astrisk beside the piece of equipment - this works in the detail section for all the records with OffCampus checked. Textbox =IIf([OffCampus]=True,"*","").
In the header section I have another Textbox =IIf([OffCampus]=True,"*OffCampus Address",""). This textbox works for some some of the employees that have offcampus equipment, but not for others. I don't understand why the if statement works in the detail section, but not in the header section. Can someone point me in the right direction? Thanks