AnsweredAssumed Answered

Help - Start date and End date total rental cost?

Question asked by Bricktop on Sep 12, 2010
Latest reply on Sep 21, 2010 by Bricktop

Title

Help - Start date and End date total rental cost?

Post

Hi All,

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

Outcomes