format for minutes, seconds and hundreths of a second

S

Stephen Morris

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

John Vinson

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