If condetion in the Qurey

[aamm]

Dear all,

I wount to wirte IF condetion in the access , can any boday help me in this

If the sales more then 10% = 25
if the sales more then 15% = 30
if the sales more then 20% = 35
if the sales more then 25 = 40

 

[stopher]

Maybe:
Switch([sales]>0.25,40,[sales]>0.2,35,[sales]>0.15,30,[sales]>0.1,25)

Chris