S
SRadcliff
Hi all,
I'm trying to figure out how to create a report that will provide a
cumulative time result for the purposes of tracking the progress of runners
in a team race. In this case I want to present the report such that the Leg
of the Race is the First Grouping and then to present the Results by Year.
For example Leg 1 and then the cumulative time (for Years 1994 through 2000)
and then Leg 2 (for Years 1994 through 2000) and then onto Leg 3 and so on.
The cumulative time will build from Group to Group for Legs 1 through 20.
The example is as follows (NOTE that I have removed the fields which include
the runner names, pace, and distance for simplifying presentation here):
Leg Year Time Cum. Start Time End Time
1
1994 0:46:35 0:46:35 12:00:00 PM 12:46:00 PM
1995 0:47:15 0:47:15 2:00:00 PM 2:47:00 PM
1996 0:59:22 0:59:22 3:00:00 PM 3:59:00 PM
1997 1:00:34 1:00:34 12:00:00 PM 1:00:00 PM
1998 0:58:23 0:58:23 12:00:00 PM 12:58:00 PM
1999 0:43:52 0:43:52 12:00:00 PM 12:43:00 PM
2000 0:47:57 0:47:57 9:30:00 PM 10:17:00 PM
2
1994 1:05:30 1:05:30 12:00:00 PM 1:05:00 PM
1995 0:53:21 0:53:21 2:00:00 PM 2:53:00 PM
1996 0:56:00 0:56:00 3:00:00 PM 3:56:00 PM
1997 0:54:36 0:54:36 12:00:00 PM 12:54:00 PM
1998 0:49:03 0:49:03 12:00:00 PM 12:49:00 PM
1999 0:52:10 0:52:10 12:00:00 PM 12:52:00 PM
2000 0:54:04 0:54:04 9:30:00 PM 10:24:00 PM
Note: that the cumulative time for Leg 2, Year 1994 will be cumulative
(includes the Year1 Cum. Time plus Year2 Cum. Time and that the Leg Start and
End Times should behave in a similar manner and allow for switching from PM
to AM as the time progresses.
Thanks in advance...
I'm trying to figure out how to create a report that will provide a
cumulative time result for the purposes of tracking the progress of runners
in a team race. In this case I want to present the report such that the Leg
of the Race is the First Grouping and then to present the Results by Year.
For example Leg 1 and then the cumulative time (for Years 1994 through 2000)
and then Leg 2 (for Years 1994 through 2000) and then onto Leg 3 and so on.
The cumulative time will build from Group to Group for Legs 1 through 20.
The example is as follows (NOTE that I have removed the fields which include
the runner names, pace, and distance for simplifying presentation here):
Leg Year Time Cum. Start Time End Time
1
1994 0:46:35 0:46:35 12:00:00 PM 12:46:00 PM
1995 0:47:15 0:47:15 2:00:00 PM 2:47:00 PM
1996 0:59:22 0:59:22 3:00:00 PM 3:59:00 PM
1997 1:00:34 1:00:34 12:00:00 PM 1:00:00 PM
1998 0:58:23 0:58:23 12:00:00 PM 12:58:00 PM
1999 0:43:52 0:43:52 12:00:00 PM 12:43:00 PM
2000 0:47:57 0:47:57 9:30:00 PM 10:17:00 PM
2
1994 1:05:30 1:05:30 12:00:00 PM 1:05:00 PM
1995 0:53:21 0:53:21 2:00:00 PM 2:53:00 PM
1996 0:56:00 0:56:00 3:00:00 PM 3:56:00 PM
1997 0:54:36 0:54:36 12:00:00 PM 12:54:00 PM
1998 0:49:03 0:49:03 12:00:00 PM 12:49:00 PM
1999 0:52:10 0:52:10 12:00:00 PM 12:52:00 PM
2000 0:54:04 0:54:04 9:30:00 PM 10:24:00 PM
Note: that the cumulative time for Leg 2, Year 1994 will be cumulative
(includes the Year1 Cum. Time plus Year2 Cum. Time and that the Leg Start and
End Times should behave in a similar manner and allow for switching from PM
to AM as the time progresses.
Thanks in advance...