miliseconds

[Bllich]

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..

 

[pietlinden]

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\)]

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.

 

[Bllich]

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]

(e-mail address removed) wrote in @b28g2000cwb.googlegroups.com:

use integer divide \
and MOD.

example?