How do I format a report field to count yes/no check box in Acces.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to design a report that has several source input fields that are
check boxes (for yes). I've got all the data displaying, and now I am trying
to setup total fields. How do I do this?
 
try this, it's crude but it works
KB



control source for text box

=abs([checkbox1]+[checkbox2]+[checkbox3])
 
I had the same type of problem in one of my reports. In the Query, I used
the following to count the checkbox. (The checkbox is [a1]) In this case,
the box is not counted if it is not checked.

CT_OF_A1: Count(IIf([a1]=-1,[a1]))

Lee S.
 
Back
Top