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