<div>
or Expr: IIf([tran code] in(&quot;BUY&quot;,&quot;RBUY&quot;),&quot;Rule 2 Purch&quot;,&quot;Rule 2 Sales&quot;)
</div>


or Expr: IIf([tran code] in("BUY","RBUY"),"Rule 2 Purch","Rule 2 Sales")

<div>
No problem! &nbsp;I have read somewhere that using the in( ) function rather than using Or is somehow more efficient when running queries, but I have never noticed a difference. &nbsp;Maybe at least it requires less typing when you would have otherwise had to use Or multiple times.
</div>


No problem!  I have read somewhere that using the in( ) function rather than using Or is somehow more efficient when running queries, but I have never noticed a difference.  Maybe at least it requires less typing when you would have otherwise had to use Or multiple times.

<div>
<div class="content wysiwyg-content">
This should be relatively simple.. &nbsp;<br />
<br />
If Tran Code = &quot;BUY&quot; or &quot;RBUY then Rule 2 Purch else Rule 2 sales. <br />
<br />
or can it be done this way to use &quot;or&quot;?<br />
<br />
<br />
Expr: IIf([tran code]=&quot;BUY&quot; Or &quot;RBUY&quot;,&quot;Rule 2 Purch&quot;,&quot;Rule 2 Sales&quot;)<br />
<br />
Thanks in advance.
</div>
</div>


This should be relatively simple..  

If Tran Code = "BUY" or "RBUY then Rule 2 Purch else Rule 2 sales. 

or can it be done this way to use "or"?


Expr: IIf([tran code]="BUY" Or "RBUY","Rule 2 Purch","Rule 2 Sales")

Thanks in advance.

IIf statement not showing correctly

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.