How to use IF ... else statemens in query

[jGURU]

Is it possible for me to use an IF...Else statement in a query, or possibly within the textbox default value/validation properties?

What i am trying to do is this:

IF (Overdue <= 0) Then
Overdue = 0
Else
(Overdue = DateRet - DateDue)
End if

Any help would be hugely appreciated.

 

[Rob.Mills]

Use the iif statement. It's just like using if in excel only with an extra i.