Fractional seconds

[Jeroen]

Hi,

I am creating a database for a swimming association and they need to enter
100ths of a second.
The problem is, Access does not seem to support fractional seconds. I can, of
course, enter the time as a text field, but I need Access to calculate the total
time.
Maybe it is possible to use a seperate field for the 100ths and add a second to
the time field every 100 fractions using a query. Or maybe I can accomplish this
task with a little Visual Basic code?

I hope someone can help me out on this or send me in the right direction.

Thanks in advance,
Jeroen

 

[Karl E. Peterson]

I am creating a database for a swimming association and they need to enter
100ths of a second.
The problem is, Access does not seem to support fractional seconds. I can, of
course, enter the time as a text field, but I need Access to calculate the total
time.

I'd use a standard numeric (Double precision) field, probably. Why would you even
consider text?