I have a big main report with seven subreports in it. I'm trying to get
a field in main report that is the sum of each subreport's SUBTOTAL so
it is a GREAT TOTAL for the main report. Using a public variable from
the main report where I add up all subtotals does not work. I have seen
that the public variable seems to lose its global scope every time it
gets into any subreport.

It looks that it should be a simple answer, but I can't manage to find a
way of doing this.

Thanks to all for your help

Frank



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Put the following expression in the control source property of Great Toyal:

=Me!NameOfSubreport1!NameOfSubtotal1 + Me!NameOfSubreport2!NameOfSubtotal2 +
..................
Me!NameOfSubreport7!NameOfSubtotal7


--
PC Datasheet
A Resource for Access, Excel and Word Applications
resource (AT) pcdatasheet (DOT) com
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel

"Francisco Gomez" <gomezfrancisco (AT) cantv (DOT) net> wrote