<div>
the iif function in access is like the if function in excel where the if and elseif key words are not explicitly stated, but are id'd by their position in a comma separated list of expressions. i am not sure what you meant by the &quot;,0&quot; in your original expression.<br />
<br />
<br />
Over30: IIf([SumOf30To60DayDebits]<wbr />&gt;=[Balance<wbr />] And [Balance]-[CURRENT]&gt;0,[Bal<wbr />ance]-[CUR<wbr />RENT],[Sum<wbr />Of30To60Da<wbr />yDebits]-[<wbr />Balance]) &nbsp;
</div>


the iif function in access is like the if function in excel where the if and elseif key words are not explicitly stated, but are id'd by their position in a comma separated list of expressions. i am not sure what you meant by the ",0" in your original expression.


Over30: IIf([SumOf30To60DayDebits]>=[Balance] And [Balance]-[CURRENT]>0,[Balance]-[CURRENT],[SumOf30To60DayDebits]-[Balance])  

<div>
Puppydogbuddy:<br />
<br />
Thank you for the additional explanation. &nbsp;I had already accepted the previous answer.<br />
<br />
Regards
</div>


Puppydogbuddy:

Thank you for the additional explanation.  I had already accepted the previous answer.

Regards

<div>
<div class="content wysiwyg-content">
How to write an &quot;if&quot; - &quot;else if&quot; statement with the expression builder for a query?<br />
<br />
The logic for the field is [Over30]:<br />
If debits of 0-60 days &gt;=Balance<br />
Then &nbsp; &nbsp;if (bal-Current)&gt;0, [Over30] = (Bal-current) , 0<br />
Else &nbsp; &nbsp; [Over30] = debits of 0-60-current.<br />
<br />
I have tried :<br />
Over30: IIf([SumOf30To60DayDebits]<wbr />&gt;=[Balance<wbr />],(elseIIf<wbr />([Balance]<wbr />-[CURRENT]<wbr />&gt;0,[Balanc<wbr />e]-[CURREN<wbr />T],0),[Sum<wbr />Of30To60Da<wbr />yDebits]-[<wbr />Over 30])) <br />
<br />
I receive syntax error (comma) in query expression.<br />
<br />
Thanks so much!
</div>
</div>


How to write an "if" - "else if" statement with the expression builder for a query?

The logic for the field is [Over30]:
If debits of 0-60 days >=Balance
Then    if (bal-Current)>0, [Over30] = (Bal-current) , 0
Else     [Over30] = debits of 0-60-current.

I have tried :
Over30: IIf([SumOf30To60DayDebits]>=[Balance],(elseIIf([Balance]-[CURRENT]>0,[Balance]-[CURRENT],0),[SumOf30To60DayDebits]-[Over 30])) 

I receive syntax error (comma) in query expression.

Thanks so much!

How to write an if - else if statement in an access 2003 query using the expression builder?

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.