Cumulative Total in a form

[lansel]

I have created a form on which information on a trainee's performance is entered.

I have to add a field in the form that calculates weeks worked.

Each week the employee's standard hours are entered in the form.
The next week when the standard hours are entered I want it to be added to the standard hours entered from last week so I will have a cumulative total. I then want to divide the cumulative total by 40 to arrive at the weeks worked.

I tried this and several other variations and none worked.

Cumulative Hours

Cumulative Hours = Cumulative Hours Value + Standard Hours Value

or

= ([Standard Hours]) + ([Cumulative Hours]) (I put this in the properties on After Update)


C Weeks

=([Cumulative Hours]) /40

I can get a calcuation, but I can't get it to cumulate. I would appreciate any help I can get.

Thanks

lansel

 

[Stuart Heath]

Running Totals in a form

One possible solution, use the iif function within your expression in your calculated control to only include data up until the date of the current record.