IIF Statement not working

[ielamrani]

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"))

 

[ielamrani]

I solved the issue. Thanks.


=IIf([ComIRSCode]<>"G- Direct Rollover to IRA" Or [ComIRSCode]<>"BG- Direct Rollover to Roth account or Roth IRA",nz([txtGrossRoll])-nz([txtLoanPay])-nz([txtFedTax])-nz([txtStTax]),"$0.00")