You *cannot* use an Access Date/Time field for this purpose. The Date
datatype is actually stored as a count of days and fractions of a day
since midnight, December 30, 1899; it's only usable to the closest
full second, and it's best used for exact points in time, not
durations.
If you're storing (say) racing times, store the value in a Double
Float number of seconds - e.g. 5:03.255 would be stored as 303.255.
You can *display* the time in nn:ss.sss format using an expression
such as
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
