Conditional Count of Check Box

[CarrieR]

Question: I have 2 check boxes on a report, one called Technician, another Certification. I am trying to count only the technicians that are certified, such as: =Sum(IIf([Certification]=-1,[Technician])). This works great except the numbers are showing up as negatives. Can anybody help me here?

 

[glalsop]

You could use a text box with this control source:

=IIf([Technician],IIf([Certification],1,0),0)

and then set the Running Total property of the text box to 'Over Group' or 'Overall', whichever is appropriate.

-Gary

 

[glalsop]

This is a simpler control source for the text box:

=IIf([Technician] And [Certification],1,0)

-Gary

 

[CarrieR]

Thanks, but neither option above worked. The calculation I originally did is correct, just shows as a negative number. Again I want to count the number of technicians that are certified, not all the technicians.

Thx

 

[glalsop]

If you want to count when the Technician AND Certification boxes are both checked, then the control source that I supplied should work, I just didn't put the Sum fuction around it. If your numbers are correct, but they are negative, you might consider passing the entire control source to the Abs() function:

=Abs(Sum(IIf([Certification]=-1,[Technician])))

or just multiply by -1:

=(Sum(IIf([Certification]=-1,[Technician]))*(-1)

Good luck

-Gary

 

[CarrieR]

Thanks, using ABS in front worked. Appreciate the help.