<div>
=iif(Sum(Nz([01WorkHours],<wbr />0)) = 0, &quot;&quot;)
</div>


<div>
Have you tried using a custom format for the field/textbox?<br />
<br />
You could try something like this to show 0s as blank.<br />
<br />
0.00;-0.00;&quot;&quot;
</div>


stephenlecomptejr

<div>
<div class="content wysiwyg-content">
Need to build an Iif statement based on values coming up 0 to not show.<br />
<br />
I have the following control source in a text box:<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-29128184-1"><span>=Sum(Nz([01WorkHours],0))</span>
</code></pre>
<br />
But there are some values that come up 0.<br />
I want to change this to where if it's 0 - then come up blank even thought it's a numeric field.<br />
<br />
I know I can use Iif statement to make this work but having trouble with the syntax:<br />
I used this and get the #error<br />
<br />
iif(Sum(Nz([01WorkHours],0<wbr />)) = 0, Null)<br />
<br />
How do I change the above to make it work?<br />
<br />
Thank you in advance.
</div>
</div>


Need to build an Iif statement based on values coming up 0 to not show.

I have the following control source in a text box:

(CODE)

But there are some values that come up 0.
I want to change this to where if it's 0 - then come up blank even thought it's a numeric field.

I know I can use Iif statement to make this work but having trouble with the syntax:
I used this and get the #error

iif(Sum(Nz([01WorkHours],0)) = 0, Null)

How do I change the above to make it work?

Thank you in advance.

Need to build an Iif statement based on values coming up 0 to not show.

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.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.