Subreport Total on Main Report

[programmingrookie]

I have a report of employees sorted by the dept they work in. I also have a
subreport that displays the number of current budgeted employees and the
total budget for by dept. What I would like to do is sum the total budget
for all depts and display on the main form as an organization total budget.
In other words, how are multiple instances of the same subreport (dept
budgets) displayed on the main report (employees).

 

[Evi]

What about using an unlinked subreport in your main report's footer?. If
appropriate, it could be a copy of your other subreport but with the details
section removed.
Evi
Or, if it's only one number which you wish want, use DSum

 

[Al Campagna]

programmingrookie,
If I understand correctly...
In your empbudget subreport, use the report footer to total the budget.
Use your own object names.
ex. = Sum(DeptBudget)
Name that field ex. BudgetTotal.
On the main report, an unbound calculated field (ex. name =
SubBudgetTotal) with a ControlSource of...

=Reports!rptYourMainName!frmYourSubName.Report![BudgetTotal]

should diplay that value.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Elaine]

Ahhh.... to find another Excel user with a similar need. I have 3
facilities, 7 departments and need to create a master budget worksheet for
each department by facility, each facility by department, with summary
budgets for each facility and department, and totals for the entire company
budget. I have an old 3 sheet budget for another company, but it's becoming
so time-consuming editing to fit my current need. We are a non-profit
service provider and any help would be greatly appreciated! Did you complete
your worksheet?