Help - Start date and End date total rental cost?
I need some help with a start date and end date calulating the days for a rental charge.
If Item "A" rents from 09/12/10 (drop down calendar) to 09/22/10 (drop down calendar) equals 10 days
Rate of item "A" is per day is $1.00
Rate of item "A" is per week is $4.00 or equal to 4 days
so a 10 day rental would be $7.00
I need help to get the calculations to work out right and get a total. I have an Items table and an invoice table related through a lines table.
I hoping someone can please help!! Ive been up all night! Thanks