Forum Discussion
IIF (add a condition)
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
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])
