If 3 check boxes are checked =1

[Marc]

How would I go about writing an IF statement for this...I have 3 check boxes
on a report, if all 3 boxes are checked per record I need it to equal 1. How
would I write the If statement in unbound text box for that? CB1,CB2 and CB3
are all checked then the value equals 1.

Thanks

 

[Rick Brandt]

How would I go about writing an IF statement for this...I have 3
check boxes on a report, if all 3 boxes are checked per record I need
it to equal 1. How would I write the If statement in unbound text
box for that? CB1,CB2 and CB3 are all checked then the value equals
1.

Thanks

IIf(CB1 = True And CB2 = True And CB3 = True, 1, 0)

You didn't say what you wanted the value to be when the three CheckBoxes are
NOT all true. Substitute what you want for the zero above.

 

[Marc]

This is exactly what I needed. Thank you!!!

IIf(CB1 = True And CB2 = True And CB3 = True, 1, 0)

You didn't say what you wanted the value to be when the three CheckBoxes are
NOT all true. Substitute what you want for the zero above.