Adding info to a report group header

[mba1942]

I have a simple 'Client Hours' table that has a binary field (Yes/No) called 'volunteer'. It indicates if the client is a 'volunteer' or a 'member'. If a volunteer, the Yes/No field is checked.

The reported hours are summed each month by Volunteer and by Member. The 'Volunteer' report group allows the differentiation and summing between the two.

I have placed the 'volunteer' binary field in the group header. When prieviewed/printed it shows as a checked box for the 'volunteer' summary and an unchecked box for the 'Member' summary.

In addition to just the binary 'box' showing in the group headers, is there a way to test the true/false status of 'volunteer' and add a text-box in the group header for showing "Volunteer" or "Member"?

Thank you for your help!
MBA

 

[cookiegary01]

Hi MBA,
Try adding a Text box to the header. Inside this you could type: =Iif([Volunteer]=-1;"Volunteer" ;" Member").
That should do the trick

 

[mba1942]

It works! Thank you so much for your help!
Note: Without success, I had tried something similar to your suggestion using
Iif(Volunteer,"Volunteer", "Member") assuming a true/false test on the binary 'Volunteer" field.
Your direction did the trick!
MBA