Accessing a field in a subreport

[Guest]

I have a subreport in the footer of a main report. The subreport has a field called balance in the detail section and a totalbalance field = sum(balance) in the footer of the subreport

How do I reference the totalbalance field in the main report footer? I would like to add the totalbalance value to another value in the main report footer and display the sum, but I keep getting an error every time I try. Is this a syntax problem, or do I need a function to obtain the value

Any help would be appreciated

 

[Duane Hookom]

Try:
=IIf(srptName.Report.HasData,srptName.Report.TotalBalance,0)+[AnotherValue]

--
Duane Hookom
MS Access MVP

I have a subreport in the footer of a main report. The subreport has a

field called balance in the detail section and a totalbalance field =
sum(balance) in the footer of the subreport.

How do I reference the totalbalance field in the main report footer? I

would like to add the totalbalance value to another value in the main report
footer and display the sum, but I keep getting an error every time I try.
Is this a syntax problem, or do I need a function to obtain the value.