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.