<div>
Or alternatively, use Nz([SumOfQTY_ORDERED],&quot;&quot;)<br />
<br />
But don't give me points for this answer please - Rey was here before me.
</div>


Or alternatively, use Nz([SumOfQTY_ORDERED],"")

But don't give me points for this answer please - Rey was here before me.

<div>
I don't think you need ANY of the hard brackets, as you are not using a field with a space or other &quot;illegal&quot; character. It might clear it all up.
</div>


I don't think you need ANY of the hard brackets, as you are not using a field with a space or other "illegal" character. It might clear it all up.

<div>
No points please.<br />
<br />
As indicated, removing all of the [ and ] brackets should solve your problem, but I agree with Phillip, I would recommend using the NZ function<br />
<br />
Qty On Hand: NZ([SumOfQTY_ORDERED],0)
</div>


No points please.

As indicated, removing all of the [ and ] brackets should solve your problem, but I agree with Phillip, I would recommend using the NZ function

Qty On Hand: NZ([SumOfQTY_ORDERED],0)

<div>
<div class="content wysiwyg-content">
What is wrong with:<br />
<br />
Qty On Hand: IIf(IsNull([SumOfQTY_ORDER<wbr />ED]),0,[[S<wbr />umOfQTY_OR<wbr />DERED])
</div>
</div>


What is wrong with:

Qty On Hand: IIf(IsNull([SumOfQTY_ORDERED]),0,[[SumOfQTY_ORDERED])

Help with query criteria and isnull

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.