Hi,

I have a database that (among other things) tracks the duration of a
given task. I would like to include a calculation field that adds the
previous records duration tasks and displays them in the current
record for example:

Record No. Duration Cumulative Current Cumulative
1 10 min 0 10
2 15 10 25
3 3 25 28
4 22 28 50
5 16 50 66

If I am displaying a layout with the record 3 data, I want it to
return a value 25 (the sum of records 1 and 2). I may want an
additional field that adds the previous records + the current record
for a value of 28 min on record three. I am needing some guidance on
how to script the Cumulative and Current Cumulative fields.

Any assistance is greatly appreciated.

Many thanks,
Antonio

Calculations deal with the current record, while relationships may cover
many records, so the idea would be to combine the two, with something
like :
"Cumul = SUM(self relationship based on the task ID:uration)"
Remi-Noel


"Reef Diver" <reef (AT) home (DOT) com> a écrit dans le message de news:
mna4g19ev6l9ca7nolmdvku1kcvi63trk9 (AT) 4ax (DOT) com...

If you want to show the running total for the found set, consider creating a
summary field and using the "running total" option.


--

Chris Cain
Extensitech, Inc.
ccain (AT) extensitech (DOT) com


"Reef Diver" <reef (AT) home (DOT) com> wrote

Perfect. Exactly what I needed. THANK YOU!!!

Now the additional thing I want to do, is get that same calculated
value from the previous record and display it in the current trecord.
Is there an easy way to do this?




On Mon, 22 Aug 2005 17:32:32 GMT, "Shadenfroh" <shadenfroh (AT) yahoo (DOT) com>
wrote: