Hi,
I have a report where one field (named Enrollment) is a checkbox. I want to count all the checkboxes with a check and ignore the boxes not checked. What expression can I use in a field in my report footer to count those checks?
Thanks!
Hi,
I have a report where one field (named Enrollment) is a checkbox. I want to count all the checkboxes with a check and ignore the boxes not checked. What expression can I use in a field in my report footer to count those checks?
Thanks!
Try something like:
=Sum(IIf([Enrollment] = True, 1, 0))
That's what I needed. Thanks.