miliseconds

Bllich

unread,

Oct 4, 2006, 8:04:18 PM10/4/06

to

Hello.
I have a problem with setting up time format in Access that I need..
I have to have something like this HH:MM:SS:MMM
that is hour:minutes:seconds:miliseconds
and be able to sum miliseconds like 500+700=1200ms=1s and 200ms
Please help..

--

When your hammer is C++, everything begins to look like a thumb.
(Steve Hoflich)

pietl...@hotmail.com

unread,

Oct 4, 2006, 8:16:45 PM10/4/06

to

Bllich wrote:
> Hello.
> I have a problem with setting up time format in Access that I need..
> I have to have something like this HH:MM:SS:MMM
> that is hour:minutes:seconds:miliseconds
> and be able to sum miliseconds like 500+700=1200ms=1s and 200ms
> Please help..
>

use integer divide \
and MOD.

Ken Snell (MVP)

unread,

Oct 4, 2006, 8:18:34 PM10/4/06

to

ACCESS does not easily nor accurately store milliseconds in its normal
date/time data type. What typically is done is to store the total number of
milliseconds as a numeric value in a field, then do calculations to convert
to "full" time or to calculate "elapsed" or "total" time.
--

Ken Snell
<MS ACCESS MVP>

"Bllich" <x...@xxx.xxx> wrote in message
news:Xns985315143...@195.29.150.88...

John Mishefske

unread,

Oct 4, 2006, 10:51:07 PM10/4/06

to

Bllich wrote:
> Hello.
> I have a problem with setting up time format in Access that I need..
> I have to have something like this HH:MM:SS:MMM
> that is hour:minutes:seconds:miliseconds
> and be able to sum miliseconds like 500+700=1200ms=1s and 200ms
> Please help..

There are some functions on this web page that may help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/Lightweight.asp

--
'---------------
'John Mishefske
'---------------

Bllich

unread,

Oct 5, 2006, 5:23:18 AM10/5/06

to

"Ken Snell \(MVP\)" <kthsne...@ncoomcastt.renaetl> wrote in
news:OIKLzOB6...@TK2MSFTNGP02.phx.gbl:

> ACCESS does not easily nor accurately store milliseconds in its normal
> date/time data type. What typically is done is to store the total
> number of milliseconds as a numeric value in a field, then do
> calculations to convert to "full" time or to calculate "elapsed" or
> "total" time.

I also thought of that and that's what I'm gonna do!

thank you all!

Bllich

unread,

Oct 5, 2006, 5:23:50 AM10/5/06

to

pietl...@hotmail.com wrote in news:1160007405.081526.203090
@b28g2000cwb.googlegroups.com:

> use integer divide \
> and MOD.

example?