Nested Subform Totals

[Guest]

I have a mani form with a nested (outer) subform, which has a nested (inner) subform within it. I've been able to calculate a total for a currency field on the inner subform and display it on the inner subform footer. However, I want to be able to show a rolled up total for the outer subform as well and display it on the outer subform footer, and then do likewise for the grand total at the main form level.

The data is organized as follows:
The inner subform layer is a series of workitems for a job
The outer subform layer is a series of projects, each consisting of workitems.
The main form layer is a series of contractors, each consisting of multiple projects.

The totals that I'm trying to calculate are:
The cost for a job, by summing the cost of all workitems in the job. This works fine.
The cost for a project, by summing the cost of all jobs.
The cost for a contractor, by summing the costs of all projects.

Is there an easier way than running a totals query for the 2nd and 3rd totals?

Any help will be much appreciated.

George

 

[Gary Miller]

DSum could also work, although not near as efficient as a
Totals Query. Neither are very difficult.

Gary Miller

message

I have a mani form with a nested (outer) subform, which

has a nested (inner) subform within it. I've been able to
calculate a total for a currency field on the inner subform
and display it on the inner subform footer. However, I want
to be able to show a rolled up total for the outer subform
as well and display it on the outer subform footer, and then
do likewise for the grand total at the main form level.

The data is organized as follows:
The inner subform layer is a series of workitems for a job
The outer subform layer is a series of projects, each consisting of workitems.
The main form layer is a series of contractors, each

consisting of multiple projects.