Counting Yes/No Fields

[David Ball]

Hi,

I have a field called "Approved" that has a check box. When an item is approved the check box is ticked.

I have created a report that has a column of check boxes. In the report footer I have added a Text Box and set the Control Source to =Count (*) to show the totals number of rows in the report. I now want to show how many items have been approved (ie, the check box has been ticked).

I have added another Text Box and set the Control Source to =Count ([Approved]). This shows the total of all check boxes, both ticked and unticked. How can I make it count the number of check boxes that are ticked. I need it to somehow detect the "yes" or "-1" values.


Thank you very much

Dave B

 

[John Big Booty]

Try = Sum(Abs(Approved))

 

[David Ball]

Thanks,

Works very well! The only thing, I found I had to add the brackets [ ].


Thanks again.

Dave B

 

[David Ball]

I had a gap between my letters in "Approved" just noticed.

 

[John Big Booty]

Glad you got it working