Work to with hundredths of seconds in Access?

[Guest]

I can get Excel to work with hundredths by formating to ss.00, How can I do
this in Access? I am trying to create a database to capture and calculate
swim times (35 seconds and 78 hundredths).

 

[John Vinson]

I can get Excel to work with hundredths by formating to ss.00, How can I do
this in Access? I am trying to create a database to capture and calculate
swim times (35 seconds and 78 hundredths).

Store the times as seconds and fractional seconds in a Single or
Double Float Number - not in a date/time field. Date/time values are
accurate only to the second, and are best used for points in time, not
for durations.

John W. Vinson[MVP]