<div>
They will always be either 0, or 1, or empty. &nbsp;The answer above would be 2 because there are 2 &quot;1's&quot;
</div>


They will always be either 0, or 1, or empty.  The answer above would be 2 because there are 2 "1's"

<div>
<div class="content wysiwyg-content">
Using this attachment...<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/10_w42/877875/Draft.jpg" target="_blank" title="Example (16 KB)"><img alt="Example" class="file-block lazyload" style="max-width: 661px;" data-src="https://filedb.experts-exchange.com/incoming/2014/10_w42/877875/Draft.jpg" /></a><br />
I need to count the number of times a &quot;1&quot; appears. &nbsp;So in this example the answer would be 2.<br />
<br />
How can I achieve this?
</div>
</div>


Draft.jpg

Using this attachment...



I need to count the number of times a "1" appears.  So in this example the answer would be 2.

How can I achieve this?

Count number of times &quot;1&quot; appears in a row 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.

Count number of times &quot;1&quot; appears in a row on a report

Count number of times "1" appears in a row on a report