Running total across records

[johnrh]

I have a need to produce database which shows the cumulative time in seconds between a number of events (about 10-30sec each) each stored in the same field in different records. I know I can use a summary field to show the running cumative total of seconds from the start but I need to also show the individual "lap" splits between say for example the value in record 2 and that in record 1. Then the difference between the value in record 3 and that in record 2 etc. Right through to the end of the file such that irf I add up the individual lap times I will finish up with the total time.

I cannot see how to take a value out of a field in record 2 and substract value in record 1 to ogive the the individual time difference.

Any quick ideas please.

[Ugo DI LUCA]

Hi,

May be a running total could help.

Check www.buliga.it for Giuseppe Pupita's Running Portal (also available at fmfiles.com I think).

[RussBaker]

John,

Looking at what I think you're doing...

1. Summaries and running totals will work, but they will be too slow to calculate for real-time race results.

2. You can capture previous lap times by going to the previous record and then copy/pasting or setting globals. This may sound slower than (1) but once you start getting thousands of lap records in your file, it is much quicker.

3. I have a fully developed FileMaker multi-lap, multi-category race system which we have used in Australia since 2000 for mountain bike races, triathlons, XTERRA races, long distance swims etc... So, you might be about to duplicate a lot of effort. Have sent you a separate email.