Time Field

[Tony McGee]

I am trying to set up an Access Database to record swimming times in the
format

MM:SS.HH

where MM = minutes (2 digits)
SS = seconds (2 digits)
HH = hundreths of a second (2 digits)

I've tried creating a Date/Time field & setting the format to nn:ss".00" ,
but this does not seem to work.

In Visual Basic, I would use the format MM:SS.00

Can anyone please help me

Thanks

Tony McGee

 

[John Vinson]

I am trying to set up an Access Database to record swimming times in the
format

MM:SS.HH

where MM = minutes (2 digits)
SS = seconds (2 digits)
HH = hundreths of a second (2 digits)

I've tried creating a Date/Time field & setting the format to nn:ss".00" ,
but this does not seem to work.

In Visual Basic, I would use the format MM:SS.00

That would be nice, but it's not supported in Access. :-{( Date/Time
fields are limited to one-second granularity.

I'd suggest storing the race time in a Single or Double count of
seconds (e.g. 4:30.28 would be stored as 270.28). You can display it
using an expression like

[RaceTime] \ 60 & Format([RaceTime] - 60 * [RaceTime] \ 60, ":00.00")

and use a couple of unbound textboxes, txtMin and txtSec, on your form
for data entry; update a bound txtRaceTime field in each of their
AfterUpdate events.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps