Combining date and time values using DateDiff

[dmpcs]

Hi, thanks to all for such a great and knowledgeable forum!

I'm trying to create my own database dealing with hiring bikes on a daily basis.
I have created a form for the basic input, including StartDate, StartTime, EndDate and EndTime, followed by TotalDays. I added the time field so that if a client brings a bike back an hour or two after the pickup time on a later date (sounds complicated - e.g he takes it on Monday at 12pm until Thursday 14pm) then he would be charged for an extra day. It is similar to the car rental system used worldwide.
The TotalDays is currently using a simple expression =EndDate-StartDate.
Is there any way to make the form incorporate the time difference so that if EndTime-StartTime>1 then it would add an extra day to the "=EndDate-StartDate" calculation.



I hope this is clear...

[lfpm062010]

Couple observations.

1) There is no need to split the date and time in 2 different fields. The date time type can store both date and time.
2) Using DateDiff will calculate using the EndDateTime - StartDateTime.

http://www.techonthenet.com/access/f...e/datediff.php