I am trying to build a query that will take a large amount of data that is sent to me so I can be able to allocate charges to users of a particular thing. The only problem is it is a phone line and for each different way of connecting, 800 number, dial up, VPN, there is a different discount given to us.
My question is how I can write an If statement that allows me to say that if a field is a, b, c, multiply it by .30, and if a feild is d and e, multiply it by .17. Is there any way I can do this?
thank you
My question is how I can write an If statement that allows me to say that if a field is a, b, c, multiply it by .30, and if a feild is d and e, multiply it by .17. Is there any way I can do this?
thank you