Counting

[Lyncroft]

I've a report with a group by title (doctor, mr, mrs). Within each group there are 5 field headings (Excel, Access, Word, etc). If they've attended the course they get a tick.

Is there a way I can count up the number of ticks within each group for each course. Eg,

Doctor

Staff id Word Excel Access
1 Tick Tick
2 Tick
3 Tick Tick

Total = 2 Total - 2 Total = 1


Mrs
As above

 

[llkhoutx]

Your "Total" makes no sense to me, but you're smarter that I am.

 

[Rich]

=Sum(Iif([MyCheckBox]=True,1,0))

 

[Lyncroft]

Cheers Rich - I'll take a look at that - thanks for the advice.

llkhoutx - thanks for your constructive help - it was a wow.

 

[Lyncroft]

llkhoutx - sorry, this has really got my back up. If you've nothing postive to say, don't bother replying.