Calculating time to the 100th of a second

[rcrane]

I have basic MS Access knowledge at a beginner level. I host running race events and know that virtually everything I need to build my database is possible in Access. The only part I am concerned about is the timing. Can Access handle timing to 100^th of a second? Can it calculate and rank based off of those times? I have searched the internet and know that it can do time calculation but I have not really found anything that conclusively convinces me that it can handle time to the 100^th of a second.

[ranman256]

the timer measures in 1000th sec. but I dont think the DATE/TIME field can. (seconds)
maybe if you add another numeric SINGLE col. you can save the normal DATE/TIME in its field, then use the timer ticks to save 100ths secs in this 2nd field.

timer ticks: 1000 = 1 second.

[isladogs]

Yes Access can easily cope with centisecond timing.
See my web article Timer Comparison Tests. This compares 6 different methods of measuring time to 1 millisecond precision or even less in the case of the High Resolution Timer.

[rcrane]

Yes Access can easily cope with centisecond timing.
See my web article Timer Comparison Tests. This compares 6 different methods of measuring time to 1 millisecond precision or even less in the case of the High Resolution Timer.

That answers my question. Thank you!

[pbaldy]

Post 4 was moderated, I'm posting to trigger email notifications.