How to discount a number by a percentage

[hemmjonny]

Hi all,

I am trying to think of the best way to discount a number from an access db.

Basically it’s an online hotel room tariff. So if someone clicks they want to stay 5 nights I want to be able to call the base price from the db and then times it by 5 and then discount a percentage per night. Or have I just made this way too complicated and over looked an easier solution.

Thanks

Jonathan

 

[r937]

price_per_night * number_of_nights * ( 100 - discount_percentage ) * 0.01

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[hemmjonny]

Hi mate,

Thanks for you reply. sorry i did not make it clear but what i want is if they stay for say 2 nights they can have a discount of say 10% and if they stay for say 4 nights they can have a discount of 15% so on and so on.

maybe i could do what you have done and then wrap it in a CFIF and then do a few of them with differnt percentage's do you think that would work?

Thanks

Jonathan

 

[r937]

yes, that would work

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon