how to use If condition?
Posted on 2009-04-09
I have a loan amount with different values
if loan amount > 30,000 then points should be 10
else if is loan amount between 15,000 and 29,999 points should be 6
Else if loan amout between 10,000 and 14,999 points should be 3
how can i do that in access:)
can anyone help me?