Time data type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dimitris - 26 May 2005 06:45 GMT

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 .

Reply to this Message

Klatuu - 26 May 2005 17:35 GMT

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.

> Hello !
> What do I have to do in order to store and short time with the following
[quoted text clipped - 4 lines]
> Any help will be appreciated .
> Thanks .

Reply to this Message

Douglas J. Steele - 26 May 2005 23:42 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hello !
> What do I have to do in order to store and short time with the following
[quoted text clipped - 5 lines]
> Any help will be appreciated .
> Thanks .

Reply to this Message

Klatuu - 27 May 2005 13:47 GMT

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.

> As Klatuu points out, the Date/Time data type in Access does not go down to
> the millisecond level.
[quoted text clipped - 12 lines]
> > Any help will be appreciated .
> > Thanks .

Reply to this Message