runners time format

[Guest]

Access 2002 - table to store track runner times in ##:##.## where it saves
the minutes:seconds.miliseconds, each with two digits.

I can't get a format to work for me - Can you help? In searching this forum
for an answer I did happen upon some SQL code but I need to know what to put
in the properties section of the table. THANKS!

 

[Guest]

The Date/Time format in Access won't handle milliseconds. You might be better
off putting the information into three fields: Minutes Seconds Milleseconds.
Then you could combine the and do the math as needed.

Coincidentially I just changes a field in an Oracle database from DATE to
TIMESTAMP which will handle a lot of milliseconds.

 

[Tom Ellison]

Dear Maureen:

I would use the Currency/Money datatypes to store this, with the time in
seconds. Write functions to convert the input from the format you desire,
and to take the value and redisplay it.

Tom Ellison