Totaling values from a sub report

S

SteveH

I have a report that shows item cost and labor cost. There is also a sub
report that shows the details of each item. I have two fields on the details
sub report that keep a running total of the two costs. I would like to show
these costs on the report footer of the main report. I tried setting the a
control's source to =[rptEstimate].[Report]![txtTotalCost] but that didn't
work. Do you have any suggestions for me? All help is greatly appreciated.
 
D

Dale_Fye via AccessMonster.com

is [rptEstimate] the name of the subreport, or the name of the control that
has "rptEstimate" as it's source object.

Typically, the way to refer to a control on a subform/report is:

[MainReportName]![SubreportControlName].Report.txtTotalCost

or

me.[SubreportControlName].Report.txtTotalCost

Dale
I have a report that shows item cost and labor cost. There is also a sub
report that shows the details of each item. I have two fields on the details
sub report that keep a running total of the two costs. I would like to show
these costs on the report footer of the main report. I tried setting the a
control's source to =[rptEstimate].[Report]![txtTotalCost] but that didn't
work. Do you have any suggestions for me? All help is greatly appreciated.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Report Group Footer DLookUp 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Global layouts 0
Creating Summary Reports from Two Tables 2
How to create a bubble chart with more than 2 variables. 0
Creating a Total from a Sub Report 1

Top