<div>
You can use Nz for that.<br />
<br />
Calc:Nz([Field2])-Nz([Fiel<wbr />d1])
</div>


You can use Nz for that.

Calc:Nz([Field2])-Nz([Field1])

<div>
try<br />
<br />
expr: Nz([Field2],0)-Nz([Field1]<wbr />,0)
</div>


<div>
<div class="content wysiwyg-content">
Could anyone advice how I force a zero into a blank field in a query:<br />
<br />
I have 2 cost columns and just want to deduct one from the other, so I need to force a zero into one of the columns where is doesn't return a value.
</div>
</div>


Could anyone advice how I force a zero into a blank field in a query:

I have 2 cost columns and just want to deduct one from the other, so I need to force a zero into one of the columns where is doesn't return a value.

How to force a zero into a blank field via a query in Access 2010

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.