Thread: Elapsed time field
View Single Post
  #2  
Old September 28th, 2008, 03:54 AM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
  
Posts: 18,261
Default Elapsed time field
On Sat, 27 Sep 2008 12:09:01 -0700, Chris Warner Chris
wrote:

I am trying to create a Training Log database for running and do not know how
to format the runnin gtimes. I want a field that can store elapsed time in
minutes:second, but do not know the format to use in the Table

I'd suggest stroring the running times (is this physically running around a
track, as opposed to say running a video? doesn't much matter) as a Long
Integer count of seconds. For example a running time of 4 minutes 15 seconds
would be stored as 255.

You can *display* this value as minutes:seconds with an expresson like

[runtime] \ 60 & Format([runtime] MOD 60, "\:00")

The advantage of storing seconds as a number is that the runtimes can easily
be sorted, averaged, summed and so on.
--

John W. Vinson [MVP]