Thursday, January 26, 2012

In Microsoft Access, how do you calculate percentage discount?

I have a field called Weekly Rate, and I need to figure out how to list each weekly rate after a 15% discount. How would I do this?In Microsoft Access, how do you calculate percentage discount?
A 15% discount leaves you with 85% of the price (100 - 15), so 0.85 * weekly_rate is the weekly rate with a 15% discount.In Microsoft Access, how do you calculate percentage discount?
You'd just need to take the weekly rate and multiply it by 0.15 and that will give you the discount. Then return that field. So on the format property line, return $ #,##.00;($ #,##.00);$ 0.00



-Ryan M., Server Engineer @ http://www.hosting.com

No comments:

Post a Comment