HELP with the Count function

[kiwigirl007]

Can anyone help? I'm running a report that shows conference delegates names and the various workshop options they are choosing for an event. What I am trying to do is work out if there is a way to count the number of people who will be in each workshop. I have set up the database so that when someone registers for a workshop, I show this through a Yes/No box (ie, put a tick in the box). So my end report looks something like this:

Name Workshop 1 Workshop 2 Workshop 3 Workshop 4
Person 1 [tick] [ ] [ ] [tick]
Person 2 [ ] [tick] [ ] [tick] ….and so on

I have managed to count each column by the following control source: =count([workshop 1]) ; =count([workshop 2]) etc. The problem is the number it gives me is the TOTAL number, not just the number of ‘yes’s’ or ticks.

Is there something I can add to my statement to get the formula to just count the ticks? I tried: =count([workshop 2]=YES (and TRUE), but it still counted the total boxes/lines. Basically I don’t want to include the ‘no' boxes in my count.

ANY HELP anyone can give would be HUGELY appreciated. Thanks

 

[ansentry]

In an unbound text box in your report footer put this

=Abs(Sum([Workshop 1]))

May I suggest that you do not use Workshop 1 instead use Workshop1 or Workshop_1

Hope it works out for you.