<div>
I have not heard of a CNT function... could it be a variable name?<br />
<br />
&nbsp;- sinjin
</div>


I have not heard of a CNT function... could it be a variable name?

 - sinjin

<div>
Double-click on the cnt, then right-click:Definition, and see what pops up.<br />
<br />
Either cnt is a function/sub used by another object model not commonly used in Access, or it is a custom public function/sub.
</div>


Double-click on the cnt, then right-click:Definition, and see what pops up.

Either cnt is a function/sub used by another object model not commonly used in Access, or it is a custom public function/sub.

<div>
Or as sinjin posted above a variable, perhaps an array.
</div>


Or as sinjin posted above a variable, perhaps an array.

<div>
It is used in report footer (report created by someone else)<br />
<br />
=Sum(cnt([OCL]))<br />
<br />
OCL is one of the fields in table. &nbsp;I don't think definition will work there
</div>


It is used in report footer (report created by someone else)

=Sum(cnt([OCL]))

OCL is one of the fields in table.  I don't think definition will work there

<div>
<div class="content wysiwyg-content">
What's the purpose of cnt() functions that is used in calculation in queries or reports<br />
<br />
example<br />
<br />
cnt(sum(&quot;field name&quot;)
</div>
</div>


What's the purpose of cnt() functions that is used in calculation in queries or reports

example

cnt(sum("field name")

cnt function

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.