Access IIf function in MS Access

[vijayag]

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

 

[vijayag]

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