I am trying to record results for athletics meetings and cannot format the
time cell to accept the data in the above format. Any help much appreciated.
Access Date/Time fields are only displayable to integer seconds. They're
actually stored as a Double Float count of days and fractions of a day since
midnight December 30, 1899 - which means that they're accurate to about 100
microseconds - but you can only *use* the data to the nearest second.
I'd suggest storing the race times in a Double Float number of seconds (e.g.
4min32.84sec would be stored as 272.84). You can format this for display
purposes with an expression like
[Runtime] \ 60 & Format([Runtime] - ([Runtime] \ 60) * 60, "\:00.000")
John W. Vinson [MVP]
