Count a field that meet one of 3 checkbox conditions (trues)

[fatboymedic]

Hi, I have a database that includes (among others) fields for NAME (3 fields per record) and an "IN CHARGE" checkbox for each NAME field.



I have already successfully created sum text boxes in a report based on a query of the data that tells me:
1)total number of records for name
2)total # of times "in charge" as NAME1
3)total # of times "in charge" as NAME2
4)total # of times "in charge" as NAME3

What I need is a report field that tells me a count (or sum??) of another field (ie:review required) which is a combo box with Y/N/naONLY if checkbox 1,2or3 is TRUE... All 3 checboxes MAY be blank (and therefore wouldnt be counted) i understand i'd have to change the formula slightly to have totals for the 3 different values of the combo box.. the person (name) may be in NAME1,2 or 3 and would only be marked "in charge" if in fact, in charge....

Im trying to get a result like:

NAME CRITERIA YES NO n/a <----- "in charge"
review required 5 37 1

GROUP CRITERIA YES NO n/a I have already
review required 30 110 4 made these

[June7]

These are Yes/No datatype fields? You want to count only if any one of the checkboxes is checked?

Sum(IIf(Name1=-1 Or Name2=-1 Or Name3=-1,1,0))