<div>
Thanks for that, although for some reason all that seems to give me is the total number of checkboxes (ie - 60, and there are 60 clients on the system) as opposed to the number which are checked (which is just 4)<br />
<br />
Sorry too this question seems to have partially ended up in the C# programming category which wasn't intended...!
</div>


Thanks for that, although for some reason all that seems to give me is the total number of checkboxes (ie - 60, and there are 60 clients on the system) as opposed to the number which are checked (which is just 4)

Sorry too this question seems to have partially ended up in the C# programming category which wasn't intended...!

<div>
I think jimhorn meant to say<br />
=Abs(Sum(YourCheckBoxField<wbr />))<br />
<br />
OM Gang<br />
<br />
PS - I don't want the points - typo on jim's part
</div>


I think jimhorn meant to say
=Abs(Sum(YourCheckBoxField))

OM Gang

PS - I don't want the points - typo on jim's part

<div>
Thanks for that - works great now
</div>


<div>
<div class="content wysiwyg-content">
Hi there. &nbsp;I need to count the number of cases with a checked box for a particular field on a report attached to the table, but am not sure how to do this - have had a look elsewhere on EE but can only seem to find how to do this on a form in a live sense, which I don't need to do - I just need a count to appear on the report. &nbsp;Any idea how I do that? &nbsp;
</div>
</div>


Hi there.  I need to count the number of cases with a checked box for a particular field on a report attached to the table, but am not sure how to do this - have had a look elsewhere on EE but can only seem to find how to do this on a form in a live sense, which I don't need to do - I just need a count to appear on the report.  Any idea how I do that?  

How do I count the number of checked boxes on a report?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).