mm:ss.00 minutes,seconds, miliseconds

  • Thread starter Thread starter Guest
  • Start date Start date
How can I enter this into a table?? Tables, queries, forms do not recognize
this.
Click to expand...

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

[Racetime] \ 60 & Format([Racetime] - 60*([Racetime] \ 60), ":00.000")


John W. Vinson[MVP]
 
Back
Top