Time and Access

[Ewok]

I'm trying to create a data base (table) to record
swimmming times. I am having trouble working time into
minutes:seconds and tenths of seconds.

 

[Joe Fallon]

Don't store Durations as datatype Date/Time.
Use Number Double (or something like that.)

Then format the value to display what you want.

You have to assign the unit of measure to that field in your head and then
be consistent about it.
e.g if the value is 24.5457 is that 24 minutes or 24 seconds or what?
Whatever it is, then ALL values that get store ar ein the same units!

Then you can format it out using expressions to give you 24 seconds 5457
milleseconds or whatever.