SteveL13

<div>
John, the 2nd solution worked perfectly.&nbsp; Thank you very much.
</div>


John, the 2nd solution worked perfectly.  Thank you very much.

<div>
<div class="content wysiwyg-content fr-view">
I have this code in a form field. &nbsp;<br><pre><code class="code-1 nolinks" id="code-10-29214881-1">=DSum("[TotalHours]","tblJobNumberDetail","[JobNumber] = " &amp; [Forms]![frmMoldRepairs]![frmJobNumberDetail].[Form].[txtJobNumber])</code></pre>But if the field is empty or null I get #Error. &nbsp;How can I make it read "0.00"<br><br>
</div>
</div>



I have this code in a form field.  
=DSum("[TotalHours]","tblJobNumberDetail","[JobNumber] = " & [Forms]![frmMoldRepairs]![frmJobNumberDetail].[Form].[txtJobNumber])
But if the field is empty or null I get #Error.  How can I make it read "0.00"

How make field read 0.00 if situation is empty or null

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.