I have an IIf statement that I am trying to do. My expression that I am trying to do is if the DED Code is equal to TXFE or
IIf((AllEmployeeSumoftaxablewages.[DED Code] = 'TXFE' or (AllEmployeeSumoftaxablewages.[DED Code] = 'TXUN'),[LimitTaxableWages] = 28900,0) as LimitTaxableWages
I get a syntax error in my SQL statement and LimitTaxableWages is a new field I am trying to create in this query. Please let me know. Thanks!