Qaiser Mehmood

Qaiser Mehmood

  • NA
  • 105
  • 0

database

Oct 20 2008 8:54 AM


i have  Rates table  with Fields in my Autotstop.mdb.


Car_id                  2_6DaysLowSeason                 7_13DaysLowSeason             14+DaysLowSeason 
 4                                    22                                                20                                           18  


I have a web page from where i select startdate and End date from calendar in "txtstart" and "txtend" textboxes.

my Question is that if user select for example  txtstart=2/10/2008 and txtend=7/10/2008

how i calculate the total days for rent acording to  price

 which is above mentioned i.e"2-6dayslowseason"= rent is 22
 7-13daysLow season = rent is 20


How many days?
How much totalrent?

Very Very Thanks if Solved.


Answers (1)