How do I format fractions of a second?

[Guest]

I'm building a database to use for track and swim meets. The time should be
in fractions of a second. In Excel, I can format as h:mm:ss.00 However,
this will not work in Access

 

[John Vinson]

I'm building a database to use for track and swim meets. The time should be
in fractions of a second. In Excel, I can format as h:mm:ss.00 However,
this will not work in Access

Correct. It will not work in Access. Times are limited to 1 second
accuracy, no better.

You can store duration in a Double count of seconds and fractions of a
second, and use expressions to generate a text string showing minutes
and hours.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Jamie Collins]

Correct. It will not work in Access. Times are limited to 1 second
accuracy, no better.

I think you are meant to say 'Jet' rather than 'Access'.

You can store duration in a Double count of seconds and fractions of a
second

Wouldn't DECIMAL(10,2) be more appropriate?

Jamie.

--

 

[John Vinson]

I think you are meant to say 'Jet' rather than 'Access'.

Sorry! Quite right. I was assuming the OP was using an Access .mdb,
rather than an .adp Project (much less common).

Wouldn't DECIMAL(10,2) be more appropriate?

As soon as Microsoft gets the bugs (sorting, for example) out of the
Decimal datatype... :-{(

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Jamie Collins]

As soon as Microsoft gets the bugs (sorting, for example) out of the
Decimal datatype... :-{(

Interesting. Do you have any details?

Many thanks,
Jamie.

--