swimmer's/athlete's time

[P Mitchell]

How do you set up a field to store for example, 1 min 30.23 secs for a
swimmer's time in a database table?

Peter

 

[Rick B]

Generally, you'd store each part as a separate field.

If you do a search, you should find lots of previous posts on the topic.

 

[Joseph Meehan]

How do you set up a field to store for example, 1 min 30.23 secs for a
swimmer's time in a database table?

Peter

Access does not have a discrete time field type. So you generally need
to roll your own. If you are looking to just display the data and not do
any computations with it, then I suggest using two fields one minutes
(Integer type) one seconds (decimal capable number type). If you need to do
computations like adding or subtracting, you need to convert the seconds
into a decimal of a minute (divide seconds by 60 so your 30.23 seconds
becomes 0.50383333333333333333333333333333 minutes.

 

[Jeff Boyce]

Peter

You do NOT use an Access Date/Time field -- this is designed to store
"point-in-time", not duration.

One approach is, as Rick suggests, to use separate fields for each component
(hours, minutes, seconds). Another approach would be to use a single field
to store the lowest unit of measure (seconds), then build routines to
"parse"/display it as hh:mm:ss.nn.