Sprint times

R

Ripper

How do I set up a field to store split times for a sprint? I am using the
database to hold times from a track meet and want to hold seconds and part of
seconds. eg 10.25 sec for the 100 yard dash. Anyone have an idea how I
could do this?

-
Thanks As Always
Rip
 
B

BruceM

You could go to table design view and choose Number as the field's data
type, then set decimal places to 2.
 
R

Ripper

Thanks Bruce. You know how you can get stuck on something. I NEED TIME IN
THAT BOX and not think of time as a number.

Thanks for the newsgroup slap in the face today!
 
J

John Vinson

How do I set up a field to store split times for a sprint? I am using the
database to hold times from a track meet and want to hold seconds and part of
seconds. eg 10.25 sec for the 100 yard dash. Anyone have an idea how I
could do this?

-
Thanks As Always
Rip
Click to expand...

Access Date/Time fields are not suitable for this purpose. They're
limited to one second accuracy, and there's no way around this limit;
and they're best suited for storing dates and points in time, not
durations.

You will need to store the data in a Single or Double Float number.
You can *display* that number as nn:ss.ss using an expression like

[Sprinttime] \ 60 & ":" & Format([Sprinttime] - 60 * ([Sprinttime] \
60), "00")

The \ isn't a typo, it's the integer divide operator.

I don't think Bruce intended a slap in the face; his advice was
essentially correct, if a bit too concise!

John W. Vinson[MVP]
 
Top