By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Data entry of a swimmers/athlete's time

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

Peter
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Best to store the value as a number of seconds, and write a function to
display it as minutes and seconds.

Because you want a fractional number, you cannot use the integer types. A
Double would work, but if you want to store the precise number of
milliseconds, a Currency field might be best. It will retain exactly 4
decimal places of precision (tenths of a milllisecond), and cope with values
as large as many years.

To display as minutes, use integer division by 60 (i.e. the \ operator.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"P Mitchell" <pm*******@mail.com> wrote in message
news:42********@news.chariot.net.au...
How you set up a field to store for example, 1 min 30.23 secs for a
swimmer's time in a database table?

Peter

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.