<div>
Test: Nz(IIf([TestP/F] = &quot;FT&quot; Or [TestP/F] = &quot;Pass&quot;, &quot;Y&quot;, &quot;N&quot;), &quot;&quot;)
</div>


Test: Nz(IIf([TestP/F] = "FT" Or [TestP/F] = "Pass", "Y", "N"), "")

<div>
To Simple:<br />
<br />
Test : Switch(IsNull([TestP/F]), &quot;&quot;, [TestP/F] = &quot;FT&quot; Or [TestP/F] = &quot;Pass&quot;, &quot;Y&quot;, 1 = 1, &quot;N&quot;)
</div>


To Simple:

Test : Switch(IsNull([TestP/F]), "", [TestP/F] = "FT" Or [TestP/F] = "Pass", "Y", 1 = 1, "N")

<div>
I apologize. &nbsp;I think the rules do say I should give other experts a chance to offer comments before accepting a solution. &nbsp;My fault.
</div>


I apologize.  I think the rules do say I should give other experts a chance to offer comments before accepting a solution.  My fault.

<div>
no problem here. &nbsp;I was just joking around on MSP's Too Late ... and mine should have been<br />
<br />
Too Simple ( not To Simple - key stuck)<br />
<br />
mx
</div>


no problem here.  I was just joking around on MSP's Too Late ... and mine should have been

Too Simple ( not To Simple - key stuck)

mx

<div>
<div class="content wysiwyg-content">
Pls point out what is wrong with this iif statement:<br />
<br />
Test: IIf(IsNull([TestP/F]),&quot;&quot;, iif ([TestP/F]) = &quot;FT&quot; or [TestP/F]=&quot;Pass&quot;, &quot;Y&quot;,&quot;N&quot;))<br />
<br />
Thanks.
</div>
</div>


Pls point out what is wrong with this iif statement:

Test: IIf(IsNull([TestP/F]),"", iif ([TestP/F]) = "FT" or [TestP/F]="Pass", "Y","N"))

Thanks.

IIF statement - wrong number of arguments

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.