Access IIf function in MS Access

V

vijayag

Joined
Apr 9, 2010
Messages
2
Reaction score
0
HI All,

I need help in writing a formula in MS Access (I am using Access 2000)

Here is the condition for formula

If A="No" LM = 0
If A="Yes" and B>6500 then LM = 6500*8%
If B<6500 then B*8%

please suggest me how to write the formula

Now I am directly using a formula like If B>6500 then 800 else B*8%

please do the needful

vijaya
 
Hi
I got the solution:
here it is
IIf([A]=0,0,IIf([A]=1,800,IIf([A]=2,*0.12))) AS LM
its working
thanks for your support
 
Back
Top