View Full Version : If condetion in the Qurey


aamm
09-22-2007, 04:07 AM
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

Uncle Gizmo
09-22-2007, 05:03 AM
>>>If the sales more then 10&#37;<<<<

Of What?

stopher
09-22-2007, 05:06 AM
Maybe:
Switch([sales]>0.25,40,[sales]>0.2,35,[sales]>0.15,30,[sales]>0.1,25)

Chris