Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Oct 01, 2022

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...
  • arnel_gp's avatar
    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])

Resources