converting data

D

DBane

I would like to convert the data in my access data base that is in 1/100ths
of a second to round to the nearest 1/10th of a second. Could anyone help.
Also please keep it as simple as possible as I am a truck driver by trade and
a novice in access. Thank you.
 
A

Allen Browne

A truck driver, measuring time in fractions of a second? Truck drag races?
:)

You might consider using a Currency type field for this. That will give you
accuracy to one ten-thousandths of a second, and produce no rounding errors.

Suggestions on working with this kind of data:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html
 
Top