Let me prefice this with I'm not VBA savy AT ALL... I have a yes/no data type field I want to display in a report and count. Each record has 3 fields with yes/no data types displayed horizontally across the report. I used an unbound text box to create a calculated control using an IIf statement to write the word "yes" if
-1, and "no", if 0. That works great. However, I wanted to count the yes/s and no/s under each field in the report footer. So I did another IIF and said IIf([Arrived = -1,Count([Arrived],""
- it counts all the records and not just the -1's. Any help greatly appreciated!!
-1, and "no", if 0. That works great. However, I wanted to count the yes/s and no/s under each field in the report footer. So I did another IIF and said IIf([Arrived = -1,Count([Arrived],""
- it counts all the records and not just the -1's. Any help greatly appreciated!!