Sum: Report + Subreport

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

Guest

Ive already sum the hours in my main report by setting a text box control
source to
=Sum([Hours])
I was wondering if there was an expression where i can get the sum of the
hours in my sub report (Sub Report Team Member) and added to the sum of my
main report and display it in my main report.
Thanks for anyone who can help
 
tanhus said:
Ive already sum the hours in my main report by setting a text box control
source to
=Sum([Hours])
I was wondering if there was an expression where i can get the sum of the
hours in my sub report (Sub Report Team Member) and added to the sum of my
main report and display it in my main report.
Click to expand...


Subreports must do theirown calculations (in the subreport's
report footer section). You can bring that value up to the
main report using a text box with an expression like:
subreport.Report.subtextbox
 
This is wat i have but it is not workign for me.

=[Sub Report Team Member Project].[Report By Team Member].SumHoursCategoryText

Marshall Barton said:
tanhus said:
Ive already sum the hours in my main report by setting a text box control
source to
=Sum([Hours])
I was wondering if there was an expression where i can get the sum of the
hours in my sub report (Sub Report Team Member) and added to the sum of my
main report and display it in my main report.
Click to expand...


Subreports must do theirown calculations (in the subreport's
report footer section). You can bring that value up to the
main report using a text box with an expression like:
subreport.Report.subtextbox
Click to expand...
 
Don't use the name of the report object assigned to the
subreport control (in its SourceObject property). Access
will figure that out when you use the Report property of the
subreport control.

=[Sub Report Team Member
Project].Report.SumHoursCategoryText

Note that in the above, you are implying that the name of
the subreport **control** is [Sub Report Team Member
Project]. While the control and the report object often
have the same name, they may be different. When dealing
with subform references, the name of the control is required
and the name of its report object is not used.
--
Marsh
MVP [MS Access]

This is wat i have but it is not workign for me.

=[Sub Report Team Member Project].[Report By Team Member].SumHoursCategoryText

Marshall Barton said:
tanhus said:
Ive already sum the hours in my main report by setting a text box control
source to
=Sum([Hours])
I was wondering if there was an expression where i can get the sum of the
hours in my sub report (Sub Report Team Member) and added to the sum of my
main report and display it in my main report.
Click to expand...


Subreports must do theirown calculations (in the subreport's
report footer section). You can bring that value up to the
main report using a text box with an expression like:
subreport.Report.subtextbox
Click to expand...
Click to expand...
 
Back
Top