E
Estêvão Raminhos
In an Athletics program (built in Access) I have created a report (based on
a query) that shows the number, name, sex and race time of each athlete. On
that report I'm able to calculate the difference of time of each athlete to
the first racer (creating a field on the report header with the value of the
race time field always gives me the 1rst racer's time which is then
subtracted from each athlete's race time field). What I want to do now (and
I haven't been able to do so far) is to calculate the difference of time
between each athlete. This means that I would have to know (register), row
by row, the value of the previous record time (the time of the previous
racer) so I could subtract it from the actual racer's time. How can this be
acomplished (be it directly on the report form or on the query)? Reports
seem to have no way to know in which record it is positioned in like screen
forms have...
TIA
Estêvão Raminhos
(e-mail address removed)
a query) that shows the number, name, sex and race time of each athlete. On
that report I'm able to calculate the difference of time of each athlete to
the first racer (creating a field on the report header with the value of the
race time field always gives me the 1rst racer's time which is then
subtracted from each athlete's race time field). What I want to do now (and
I haven't been able to do so far) is to calculate the difference of time
between each athlete. This means that I would have to know (register), row
by row, the value of the previous record time (the time of the previous
racer) so I could subtract it from the actual racer's time. How can this be
acomplished (be it directly on the report form or on the query)? Reports
seem to have no way to know in which record it is positioned in like screen
forms have...
TIA
Estêvão Raminhos
(e-mail address removed)