Getting totals from a multiple record 2nd level subform

[terces]

Hi Guys,

Once again I am needing an assistance, same matter with the finances and calculation referred from a multiple record on a second level subform.

here is the situation:

I have 3 tables:

Projects
Releases
Liquidations

Given that, for every project, there will be multiple tranches of funds to be released, and for every releases there will be multiple liquidations.



Being the ProjectDetailsF is my main form from Projects Table, ReleasesF form for Releases Table as subform and LiquidationsF form for liquidations table as sub-subform. Please refer to the image below.

i have extracted the totals from the subform as shown on Amount Granted by making an unbound textbox in the footer section of the subform however, same process for the subsubform cant get the same result and gives me an #error as shown on the Liquidated field.

In addition, if by any chance the totals calculation worked for a sub-subform, my another issue will be how to compute for a multiple totals (multiple releases hence 2 totals for each release) on the sub-subform like what is shown on the image below

on clearer note: i can get the total amount released for a particular project, but how can i get the total amount liquidated for a particular release and for a particular project as well. hope I don't make things complicated.

Thanks.

 

[Peter Reid]

Where is the 'subsubform' on the attached image (which looks very nice, btw)?

 

[terces]

the subsubform is not visible since it's also a subdatasheet in which you can collapse and expand from the subform