Accessing a field in a subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try:
=IIf(srptName.Report.HasData,srptName.Report.TotalBalance,0)+[AnotherValue]

--
Duane Hookom
MS Access MVP


Eric said:
I have a subreport in the footer of a main report. The subreport has a
Click to expand...
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
Click to expand...
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.
 
Back
Top