<div>
<a href="https://support.office.com/en-us/article/iif-function-32436ecf-c629-48a3-9900-647539c764e3" rel="ugc nofollow">IIF()</a> expects 3 input variables, the criteria to test for, what to do if it is TRUE, what to do if it is FALSE.<br />
If you explain what should be happening, we can try to further help.<br />
<br />
Also, ypically I would use Nz([FiledName], 0) &nbsp;to always ensure there is a numeric value being returned just in case a field is empty, Null which could cause errors to be thrown.
</div>


ajaeclarke

<div>
You are a legend Gustav! Thank you so much. :)
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am having some trouble with the below expression in a query. I am trying to get the average of three fields which allows for zero's.<br />
<br />
ACWLW: ([RELTTMALW]+[AOLTTMALW]+[<wbr />WTMALW])/I<wbr />If((-([REL<wbr />TTMALW]&lt;&gt;0<wbr />)-([AOLTTM<wbr />ALW]&lt;&gt;0)-(<wbr />[WTMALW]&lt;&gt;<wbr />0))<br />
<br />
It is telling me that The Expression you entered has a function containing the wrong number of arguments.<br />
<br />
It has been a long day and I just cannot see it!! Could somebody please enlighten me :-)<br />
<br />
Thanking you
</div>
</div>


Hi

I am having some trouble with the below expression in a query. I am trying to get the average of three fields which allows for zero's.

ACWLW: ([RELTTMALW]+[AOLTTMALW]+[WTMALW])/IIf((-([RELTTMALW]<>0)-([AOLTTMALW]<>0)-([WTMALW]<>0))

It is telling me that The Expression you entered has a function containing the wrong number of arguments.

It has been a long day and I just cannot see it!! Could somebody please enlighten me :-)

Thanking you

IIF() (https://support.office.com/en-us/article/iif-function-32436ecf-c629-48a3-9900-647539c764e3) expects 3 input variables, the criteria to test for, what to do if it is TRUE, what to do if it is FALSE.
If you explain what should be happening, we can try to further help.

Also, ypically I would use Nz([FiledName], 0)  to always ensure there is a numeric value being returned just in case a field is empty, Null which could cause errors to be thrown.

You are a legend Gustav! Thank you so much. :)

Expression has the wrong amount of arguments

Hi

I am having some trouble with the below expression in a query. I am trying to get the average of three fields which allows for zero&amp;#39;s.

ACWLW: ([RELTTMALW]+[AOLTTMALW]+[WTMALW])/IIf((-([RELTTMALW]&amp;lt;&amp;gt;0)-([AOLTTMALW]&amp;lt;&amp;gt;0)-([WTMALW]&amp;lt;&amp;gt;0))

It is telling me that The Expression you entered has a function containing the wrong number of arguments.

It has been a long day and I just cannot see it!! Could somebody please enlighten me :-)

Thanking you

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.