p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Need Help - Peak Season room Calculation


Message #1 by "Mawutor Quarshie" <mkquarshie@h...> on Tue, 05 Jun 2001 13:08:48
I am building a database for a resort reservation that I designed.But 

instead of making the cost calculation a striaght forward output,I weant to 

let access calculate the cost of each room based on the season or peak 

time.For instance,ths summer when a lot will go out to resort palces,I want 

my set up to calculate the cost as 1.25x the normal or of peak season 

cost.How do I do that and where in access.



Any help will be highly appreciated.

Thanks



Message #2 by "Darron Michael" <darron.michael@h...> on Fri, 8 Jun 2001 14:15:22
You are going to need a table containing dates or date ranges and price 

adjustment indices.  



Create a table with fields for begdate, enddate, and adjustment.  when you 

calculate your cost, look up the correct cost adjustment from this table 

based on the dates being quoted and use that adjustment as your multiplier.



Hopefully, you are using a form to enter your data.  You can create a 

query (named bubba) that uses the date field from your form as a search 

criteria to find the correct cost adjustment for that date.



You can create a subform on your form to use the results of that query to 

do the math.



Hope this helps.  8^)



Darron



Message #3 by "Mawutor Quarshie" <mkquarshie@h...> on Sun, 10 Jun 2001 08:00:52
-Oh Mike,



Thanks  for the response to my plea.I am going to set it out and will surely 

let you knnow the outcome.



Cheers.



mawutor

  Return to Index