<div>
Are you saying that your DIV field has data such as 190-HCBT and 1CAV? &nbsp;If so then these should work:<br />
<br />
=DCount(&quot;*&quot;,&quot;tblMODHistory<wbr />&quot;,&quot;190-HBC<wbr />T&quot;)/20<br />
=DCount(&quot;*&quot;,&quot;tblMODHistory<wbr />&quot;,&quot;1CAV&quot;)/<wbr />20
</div>


Are you saying that your DIV field has data such as 190-HCBT and 1CAV?  If so then these should work:

=DCount("*","tblMODHistory","190-HBCT")/20
=DCount("*","tblMODHistory","1CAV")/20

<div>
Is '190-HBCT' a field? &nbsp;if so, try enclosing it and also 'DIV' in brackets.<br />
=DCount(&quot;[DIV]&quot;,&quot;tblMODHis<wbr />tory&quot;,&quot;[19<wbr />0-HBCT]=-1<wbr />&quot;)/20
</div>


Is '190-HBCT' a field?  if so, try enclosing it and also 'DIV' in brackets.
=DCount("[DIV]","tblMODHistory","[190-HBCT]=-1")/20

<div>
Oops, as mbizup's answer shows, I forgot part of the argument in my response. &nbsp;Looks like either his answer or trbaze's would work for you depending on how you have your fields set up.
</div>


Oops, as mbizup's answer shows, I forgot part of the argument in my response.  Looks like either his answer or trbaze's would work for you depending on how you have your fields set up.

<div>
<div class="content wysiwyg-content">
I have a tabel that has a field called, DIV. In those fields are name of companies.<br />
I need the total of certain companies that are in the DIV field. I am using an unbound field to put this information in. &nbsp;<br />
<br />
<br />
So what Im trying to say is look in this table under div and find 190-HBCT and count how many times it appears. Then divide that number by 20 to get the total percentage completed by that unit.<br />
<br />
=DCount(&quot;DIV&quot;,&quot;tblMODHisto<wbr />ry&quot;,&quot;190-H<wbr />BCT=-1&quot;)/2<wbr />0<br />
=DCount(&quot;DIV&quot;,&quot;tblMODHisto<wbr />ry&quot;,&quot;1CAV=<wbr />-1&quot;)/20
</div>
</div>


I have a tabel that has a field called, DIV. In those fields are name of companies.
I need the total of certain companies that are in the DIV field. I am using an unbound field to put this information in.  


So what Im trying to say is look in this table under div and find 190-HBCT and count how many times it appears. Then divide that number by 20 to get the total percentage completed by that unit.

=DCount("DIV","tblMODHistory","190-HBCT=-1")/20
=DCount("DIV","tblMODHistory","1CAV=-1")/20

Using DCount to count certain fields in a table

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.