SOLVED

IIF (add a condition)

Steel Contributor

Hello,

How can I add another condition to the below to return [ParentSettle] if txtDtSetC is Null.  I am not sure if IIF is advisable for this? 

In English:

If txtDtSetC is NULL then return [ParentSettle]

then return as below

=IIf(Nz([txtDtSetC],0)>[ParentSettle],[txtDtSetC],[ParentSettle])

 

thank you

2 Replies
best response confirmed by Tony2021 (Steel Contributor)
Solution

is the expression in the Form?
if ParentSettle field is also in the Form or Recordsource of the form:

=IIf(Val([txtDtSetC] & "")>Val([ParentSettle] & ""),[txtDtSetC],[ParentSettle])

amazing. Works perfectly! thank you!!
1 best response

Accepted Solutions
best response confirmed by Tony2021 (Steel Contributor)
Solution

is the expression in the Form?
if ParentSettle field is also in the Form or Recordsource of the form:

=IIf(Val([txtDtSetC] & "")>Val([ParentSettle] & ""),[txtDtSetC],[ParentSettle])

View solution in original post