IF(AND Statement in a Form

[bkirsch]

I have created a relatively large "if(and" statement in MS Excel and am looking to replicate that equation in Access but keep getting an error saying I have entered a comma without a preceding value or identifier...?



The equation works perfectly in Excel...

=IF(AND(I2=TRUE,(F2=1)),H2*0.1,(IF(AND(I2=TRUE,(F2 =2)),H2*0.05,(IF(AND(I2=TRUE,(F2=3)),H2*0.02,(IF(A ND(I2=TRUE,(F2=4)),0,0)))))))


My attempt to create in Access... "1, 2, 3, 4" are all "ID" of a look up" "Payment_Received" is a check box

=IF(AND( [Payment_Received] =TRUE,( [Commission Type] =1)), [Monthly Billing Total] *0.1,(IF(AND( [Payment_Received] =TRUE,( [Commission Type] =2)), [Monthly Billing Total] *0.05,(IF(AND( [Payment_Received] =TRUE,( [Commission Type] =3)), [Monthly Billing Total] *0.02,(IF(AND( [Payment_Received] =TRUE,( [Commission Type] =4)),0,0)))))))


any suggestions would be greatly appreciated

[orange]

That is not the Access syntax
see iif http://www.techonthenet.com/access/f...vanced/iif.php

see choose http://www.techonthenet.com/access/f...ced/choose.php