Rental Database

trinismooth

HI good day...
I am using ms access 2003 to create a vehicle rental database and I am having a little problem getting the calculations for late vehicles...The problem is that late vehicles are charged by the hour and my database is set up to simply find the difference between the Expected date of return and the actual date of return then multiply the answer by the late charge, as a result if some one brings a vehicle one hour and 20 minutes late, they will not be charged for a full 2 hours...

All the help is appreciated...

Rabbit

Quote:

Originally Posted by trinismooth

HI good day...
I am using ms access 2003 to create a vehicle rental database and I am having a little problem getting the calculations for late vehicles...The problem is that late vehicles are charged by the hour and my database is set up to simply find the difference between the Expected date of return and the actual date of return then multiply the answer by the late charge, as a result if some one brings a vehicle one hour and 20 minutes late, they will not be charged for a full 2 hours...

All the help is appreciated...

You say date but I'm assuming Date/Time. Use DateDiff to find the difference in minutes, add 59 to that, use the numerator only division operator and divide by 60, multiply your rate.

trinismooth

Thanks a lot it worked

Rental Database

re: Rental Database

re: Rental Database

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about