Hi,
Can anyone see why this is not working. I am doing this in text box in a form (Access 2003). Thanks in advance
=IIF([ComIRSCode] is <> "G- Direct Rollover to IRA" or IIF([ComIRSCode] is <> "BG- Direct Rollover to Roth account or Roth IRA",(nz([txtGrossRoll]) - nz([txtLoanPay]) - nz([txtFedTax]) - nz([txtStTax])), "$0.00"))
Can anyone see why this is not working. I am doing this in text box in a form (Access 2003). Thanks in advance
=IIF([ComIRSCode] is <> "G- Direct Rollover to IRA" or IIF([ComIRSCode] is <> "BG- Direct Rollover to Roth account or Roth IRA",(nz([txtGrossRoll]) - nz([txtLoanPay]) - nz([txtFedTax]) - nz([txtStTax])), "$0.00"))