converting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding 10
Displaying Numbers 2
join tables using a key field 3
Round up 10th of Decimal 1
Access access and windows phone 0
Rounding up! 2
Is there an access template for tracking stock investments? 0
100ths of a second 2

Back
Top