summing totals in reports

[bakerboy_1111]

I have a report which is sorted by Level_No.

If I have summed a total for say Level_No 3, then can I use this result when I sum a total in Level_No 2?

For example, the result of Level_No 2 may include certain values as well as the total from Level_No 3.

 

[Michelangelo]

Assume level 3 sum textbox is called L3Text

then put in level 2 footer something like

=Sum[Level2] + [L3Text]

HTH

M.

 

[bakerboy_1111]

Thanks for the reply,

The problem I'm having is that within the report, the data is sorted by Level_No. So from the design view of the report, all Level_No data goes in the same detail section of the report. There is not actually a separate Level 2, Level 3 etc box. Therefore, I cannot reference say L3Text box, because it is the same box as L2Text box!!

I think the problem may lie in my design, I don't think I can fix this within the report....

Cheers,

Bakerboy