access cascading calculation

[jor]

I have 2 fields to calculate the and the difference of the two fields will be
added on the new field in the query. The situation is like this, the
difference result of the 1st row needs to be added in the new field. the
result in the 2nd row diff wll be added to the new field. please si sample:

onchk offchk on/offchkdiff total hrs
8:59 13:45 4:46 1110:57 => this carry over figure
8:50 12:57 4:07 1115:04
7:48 9:49 2:01 1117:05

Any assistance for this?
Thanks ni advance.

jor

 

[scubadiver]

Why start a new thread?

 

[pietlinden]

I have 2 fields to calculate the and the difference of the two fields will be
added on the new field in the query. The situation is like this, the
difference result of the 1st row needs to be added in the new field. the
result in the 2nd row diff wll be added to the new field. please si sample:

onchk offchk on/offchkdiff total hrs
8:59 13:45 4:46 1110:57 => this carry over figure
8:50 12:57 4:07 1115:04
7:48 9:49 2:01 1117:05

Any assistance for this?
Thanks ni advance.

jor

why not do it the easy way? Create a report with a running sum of
total hours? Or would that be too easy?

 

[jor]

Is it posible to do the the calculations of total hrs in the query? if so,
kindly help me to do it. I've done already the onchk offchk
onchkoffchkdifference in the query. what i need in the query is the to add
the diff 4:46 to 1106:11 which is carry forward figure and to become 1110:57.
and 1110:57 + 4:07 to become 1115:04 and so on. thanks.

jor