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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.