Need to count and total Checkboxes 2

[jb333]

Hello, I need to total Checkboxes and assign them to a differnet filed on a report. such as total students completed program and their boss is such and such and the department total is this ?? please see below.
thank you, john

Completed not completed Boss
joe no dave
sam yes dave
steve yes dave
tom yes dave

Dave total 3 completed
Dave total 1 not completed
Dave Percentage is 75% completed

 

[GingerR]

One thing that I see that is a little odd is that you have a column heading of "Not Completed" with 'NO' in it. Perhaps you should have one column heading, such as "Completed?" with the check box in it?

As for your question, one possibility is to use dcount.

You could have for example for the number of YES boxes for the Boss which is listed:

dcount("RecordID","TableName","Completed = True and Boss = '" & [txtBoss] & "'")

 

[BNPMike]

I normally asign these to a numeric field (CompCnt: IIF(Completed = true,1,0)). then you can just SUM CompCnt, NotCnt, etc...