Discussion Locked

Microsoft Access

0 helpful

4 replies

by leopold.durrant Dec 11, 2001 last reply Dec 28, 2001

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

What 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

4 replies

Here's the syntax

SSDed2: IIf([NETPay]<1950 And [NETPay]>975,39,(4/400)*[NETPay])

Good Luck!

Sorry! I forgot the = signs! Here's the correct formula: ssdet: IIf([net pay]<=1950 And [net pay]>=975,39,(4/400)*[net pay])

Poster rated this answer

This question was closed by the author

This discussion is closed to new replies.