Wonderwall99

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm having problem with the last part of my formula IIf([Column1]&gt;[Column 2],[Column 2]))). &nbsp; &nbsp;When I run the query, Column 1 is returning instead of Column 2, can you please assist?<br />
<br />
<br />
IIf([Column 1]&lt;&quot;0&quot;,&quot;0&quot;,IIf([Column 1]&lt;[Column 2],[Column1],IIf([Column1]<wbr />&gt;[Column 2],[Column 2])))
</div>
</div>


Hi,

I'm having problem with the last part of my formula IIf([Column1]>[Column 2],[Column 2]))).    When I run the query, Column 1 is returning instead of Column 2, can you please assist?


IIf([Column 1]<"0","0",IIf([Column 1]<[Column 2],[Column1],IIf([Column1]>[Column 2],[Column 2])))

Access IIf statement help

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.