format for minutes, seconds and hundreths of a second

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

Guest

does anyone know please how i can put a sports time into a database format.
 
I haven't tryed this in the newer versions of Access, but in previous builds
one can select the field type "Sports Time" from more under the data type in
database design view.
If you cannot see it, click "Lookup Wizard" as this connects to the
office.microsoft.com website and downloads the newest field types. (It did in
previous versions, anyway)
 
does anyone know please how i can put a sports time into a database format.
Click to expand...

I'd suggest using a Number of "Double" type to store seconds (e.g.
4:10.14 would be stored as 250.14). You can display this using an
expression like

[racetime] \ 60 & format([racetime] - 60*([racetime] \ 60), "00.00")

and enter times using a Form with unbound textboxes for the minutes
and seconds/fractional seconds, with a little vba code to put them
together.

John W. Vinson[MVP]
 
You must log in or register to reply here.

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

Converting Seconds to Hours, Minutes, Seconds 3
how do I format time to include fractions of a second 2
Time Field 1
convert length of time to minutes from hundreths 2
Is there an Excel format foro time to hundreths of a second 2
correlate a series of numbers in mm:ss to another column also in m 1
loss of accuracy in pivot table 3
Sports Clocking - Events Procedure Close - Few minor glitches 2

Back
Top