Can anybody tell me how I can total the instances of YES in a Yes/No field. I have tried to create an unbound box in a report and typed in =SUM([FIELDNAME]) in the “properties>control source” but always end up with an error message.
Should I be doing this directly from a query instead?
Any pointers would be greatly appreciated.
IT Guru
