Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2K totaling subreports

Status
Not open for further replies.
webjunk

webjunk

MIS
Dec 28, 1999
42
0
0
US
If I have a report called RepMain and in that report i have a sub-report called SubRepOne and in that sub-report I have a column called Cost how can I make a text box on the main report to total that one column in the subreport?

Thanks in advanced
 
Sort by date Sort by votes
Add an unbound text box to the report footer of your subreport and set its control source to:
Code: 
 =Sum([Cost])
. In the text box of your main report that you want to display the total, set its control source to the text box from your subreport's footer (something like:
Code: 
=[SubRepOne].[Report]![txtSumCost]
)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
262
renigar
renigar
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
490
EwaFAMA
EwaFAMA
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
83
GPnew
GPnew
DRU1
  • Locked
  • Question
MS ACCESS Assistance request
Replies
2
Views
87
dhookom
dhookom
ronwmon
  • Locked
  • Question
I have an access database that has
Replies
2
Views
89
ronwmon
ronwmon

Part and Inventory Search

Sponsor

Back
Top