Forum Discussion
Tony2021
Oct 01, 2022Steel Contributor
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 [Paren...
- Oct 02, 2022
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])