Objective - to record swimming times for a local club per stroke per person. We will have 2 tables one recording the events on an ongoing basis (Swim Meets) and one recording the current Personal bests per distance and stroke.

The swimmers stroke time needs to be entered into a table as: -

minutes:seconds.hundreth of a second ie 1:32.54

Currently this project is in a design stage, but this value will be manually entered by a user and needs to be in the stated format.

My question is how do I record this value as SQL and Access to not appear to understand the hundreth of a second so I do not how who to record this value! so any advice would be fantastic!

Thanks