Formulas,Formulas.....

[helmi]

I am doing a project and one part of it i dont understand how to do regarding formulas. I think we must use the expression builder but unsure.Plz help me...This is the question...

If a customer returns the car late, a surcharge of 25% of the daily rate per day shall be added to overdue rentals. What would be the total amount due for cars returned late?
i. E.g. if the car was rented for 5 days at $100 per day, and returned two days late:
ii. The Surcharge would be: 25% of $100 * 2 days = $50
iii. The rental fees would be: $100 * 7 days= $700
iv. The total amount due would be $700 + $50 = $750

 

[deduct]

Try this:
f_surgharge_amt:[f_daily_rate]*[f_days_late]*[f_surcharge_rate]
f_regular_amt:[f_daily_rate]*[f_days_car_kept]
f_total_due:[f_regular_amt]+[f_surcharge_amt] Karl

 

[ajdesalvo]

I am assuming that you have a form with the fields containing the data for this example.

The car was rented for 5 days at $100 per day, and returned two days late:
The Surcharge would be: 25% of $100 * 2 days = $50
The rental fees would be: $100 * 7 days= $700
The total amount due would be $700 + $50 = $750

Me![TotalDUe] = (Me![DaysRented] * Me![DailyRate]) + (Me![DaysOverDue] * (Me![DailyRate] * .25))

Hope this helps! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"