General discussion
-
Topic
-
Microsoft Access
LockedWhat si the correct syntax for this formula in Microsoft Access?
I want to calculate the SSDed2 if net pay is greater than $975 and less than 1950 then $39 else 4 divided by 100 X Net Pay
This is my syntax but it is wrong.
SSDed2: IIf([NETPay]>1950,87.75,4.5/100*[NETPay])
Thanks