<div>
Thanks guys for the quick response. &nbsp;Both of you were close. &nbsp;The expression below is the one that ended up giving me my needed result.<br />
<br />
DCount(&quot;[OrderID]&quot;,&quot;Orders<wbr />&quot;,IsNull(&quot;<wbr />[OrderID]&quot;<wbr />))&gt;35
</div>


Thanks guys for the quick response.  Both of you were close.  The expression below is the one that ended up giving me my needed result.

DCount("[OrderID]","Orders",IsNull("[OrderID]"))>35

<div>
Both solutions offered where very close to what I needed. &nbsp;From their suggestions, I was able to figure out what I needed.
</div>


Both solutions offered where very close to what I needed.  From their suggestions, I was able to figure out what I needed.

<div>
&quot;Both solutions offered where very close to what I needed. From their suggestions, I was able to figure out what I needed.&quot;<br />
<br />
Thx.<br />
<br />

</div>


"Both solutions offered where very close to what I needed. From their suggestions, I was able to figure out what I needed."

Thx.



<div>
<div class="content wysiwyg-content">
The expression below fires an action when &quot;There are more than 35 entries in the OrderID field of the Orders table.&quot;<br />
Code:<br />
<br />
DCount(&quot;[OrderID]&quot;, &quot;Orders&quot;)&gt;35<br />
<br />
I'm looking for a condition that would fire when &quot;There are more than 35 entries in OrderID field that are NUll for the Orders table.&quot;<br />
<br />
Any suggestions would be greatly appreciated! Thanks!
</div>
</div>


The expression below fires an action when "There are more than 35 entries in the OrderID field of the Orders table."
Code:

DCount("[OrderID]", "Orders")>35

I'm looking for a condition that would fire when "There are more than 35 entries in OrderID field that are NUll for the Orders table."

Any suggestions would be greatly appreciated! Thanks!

DCount function in a Macro Condition for MS-Access

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.