Time data type

[Dimitris]

Hello !
What do I have to do in order to store and short time with the following
form :
Hour (optional) : Minutes : Seconds . Milliseconds
The reason is because I want to store, sort data (time) and extract results
for swimmers (I'm member of a small swimming club).
Any help will be appreciated .
Thanks .

 

[Klatuu]

Look in Access Help for the Format function and check See Also to find named
time formats for formatting for your form or report. The problem you have is
that milliseconds are not carried in Access.

 

[Douglas J. Steele]

As Klatuu points out, the Date/Time data type in Access does not go down to
the millisecond level.

You're probably best off storing the times as Long Integers representing the
total number of milliseconds. It's pretty straightforward to your own
functions to convert back and forth between Milliseconds and h:mm:ss:ttt

 

[Klatuu]

Douglas,

Exactly my thoughts. It so happens I have a similar situation on the back
burner and I will be creating the functions I need to accomplish this.

Dimitris,

If you need these functions, I can send you a copy, but I don't think I will
have them done until next week some time. Let me know if you need them and
how I can get them to you.