how do I format time to include fractions of a second

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

Guest

Access 2003 - I am trying to create a db of swimming times and athletics
track times, both of which are timed to a hundreth of a second. I can create
a custom format in Excel but can not see how to do it in Access. Help please.
 
You can't, at least, not reliably.

The time in Access doesn't have that level of resolution: I think it's only
good to about 3 hundredths of a second.

What you can do is store the time as total hundredths of seconds as a Long
Integer, then write your own function to format that as hh:nn:ss.dd
 
Douglas said:
What you can do is store the time as total hundredths of seconds as a Long
Integer, then write your own function to format that as hh:nn:ss.dd
Click to expand...

Perhaps better would be to use Jet's DECIMAL which is a scaled integer
data type anyhow.
 

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

How do I format fractions of a second? 4
Entering Race Times 4
Time Field 1
Converting Seconds to Hours, Minutes, Seconds 3
How can I store time values in access 2
Work to with hundredths of seconds in Access? 1
Is there an Excel format foro time to hundreths of a second 2
hundredths of seconds 2

Back
Top