I am trying to put together a database of personal bests for a swimming club
and need to record times to hundredths of seconds. How do I do this in
Access? I can only format fields to full seconds. (I am not an expert!)
You won't be able to use a date/time field for this purpose: it's
designed to store specific moments of time, not durations, and as you
have found it's limited to one-second accuracy. (It's actually good
for some tens of microseconds but you can't display that information!)
Instead, use a <gasp> Currency datatype. It's actually not money; it's
a huge integer with exactly four decimal places. For a time of 2
minutes, 38.23 seconds you'ld store 158.2300. You can *display* it as
minutes and seconds with an expression like
[Racetime] \ 60 & Format([Racetime] - 60*([Racetime] \ 60), ":00.00")
The \ isn't a typo - it's the Access Integer divide operator, so
157.23 \ 60 is 2.
John W. Vinson[MVP]
