How can I enter this into a table?? Tables, queries, forms do not recognize
this.
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]
