Unanswered: Calculated control to count from multiple fields?
I'm creating a report based on a table which has Yes/No fields for six options. I'm trying to write an expression that will count how many records have more than one of the six, in any combination. What I've got is
You are on the right track. But to get the Yes/No fields converted to numbers you might want to try CInt to convert them to integers. In Access, True is -1 and False is 0. So you have to add up the Trues and get the Absolute Value with ABS (or multiple it by -1). Here is what I came up with: