sum calculation in subform based off of a query

[babs]

I have a Main form that has date at the link to the subform. each record is a
given DAY then the cleaning jobs are scheduled in the subform. Each cleaning
job has an est. time. In the subform many people are scheduled to do many
jobs. and same person is usually scheduled to do many jobs.
Worked hard and this is the way the form subform - we want layed out.

I would like to get a running total as each job is scheduled in the subform
- sum of est. time by person(clockid). Have the subform sorted by person so
they are all grouped together- tried putting sum of est time in footer. Many
problems with that- it sums ALL people est. total time - want it PER person.

Please help have been stuck on this for a while.

Thanks,
Barb