<div>
Use the below one...<br />
<br />
=iif(Nz([PastDueYN],&quot;&quot;)=&quot;&quot;<wbr />,IIf(Nz([t<wbr />xtComplete<wbr />d],&quot;&quot;)=&quot;&quot;,<wbr />&quot;Pending:&quot;<wbr />,&quot;Complete<wbr />d:&quot;),&quot;&quot;) <br />
<br />
Saurabh...
</div>


Use the below one...

=iif(Nz([PastDueYN],"")="",IIf(Nz([txtCompleted],"")="","Pending:","Completed:"),"")

Saurabh...

<div>
lets evaluate what you are trying to do<br />
<br />
for the first IIF expression<br />
=iif(Nz([PastDueYN],&quot;&quot;)=&quot;&quot;<wbr />, &lt;WhatValue&gt;<br />
if the expression is True, what value do you want to show in the &lt;whatValue&gt; portion
</div>


lets evaluate what you are trying to do

for the first IIF expression
=iif(Nz([PastDueYN],"")="", <WhatValue>
if the expression is True, what value do you want to show in the <whatValue> portion

<div>
Nice! &nbsp;I have to put on my glasses. &nbsp;Tough to see all of those parenth and commas. &nbsp;<br />
<br />
thank you
</div>


Nice!  I have to put on my glasses.  Tough to see all of those parenth and commas.  

thank you

<div>
<div class="content wysiwyg-content">
Experts, I get the wrong number of arguments error in the below. &nbsp;I dont know if I can do what I am trying to do. &nbsp; Let me know if you see a comma misplaced or a parenth or if my logic is completely off on this one. &nbsp;<br />
<br />
=iif(Nz([PastDueYN],&quot;&quot;)=&quot;&quot;<wbr />,IIf(Nz([t<wbr />xtComplete<wbr />d],&quot;&quot;)=&quot;&quot;,<wbr />&quot;Pending:&quot;<wbr />,&quot;Complete<wbr />d:&quot;,&quot;&quot;)
</div>
</div>


Experts, I get the wrong number of arguments error in the below.  I dont know if I can do what I am trying to do.   Let me know if you see a comma misplaced or a parenth or if my logic is completely off on this one.  

=iif(Nz([PastDueYN],"")="",IIf(Nz([txtCompleted],"")="","Pending:","Completed:","")

Nested If

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.