Help with hours and minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a field that will maintain the driving distance between cities. It
will be in hh:mm format. I tried using the date/time function but when the
distance is over 24 hours the calculations are incorrect. Please advise. I am
using Access 2003.
 
Realistically, the problem is because Access doesn't have a Time data type:
it only has the Date data type, which is intended to be a timestamp, or
specific point in time, not a duration.

However, you could check my October, 2003 "Access Answers" column in
Pinnacle Publication's "Smart Access" magazine for a work-around. You can
download the column (and sample database) for free from
http://www.accessmvp.com/djsteele/SmartAccess.html
 
Back
Top