Windows 7 64bit 
Access 2007
Hello!
I am making a report to track progress on a goal. Each person on my staff has assignments, and our team goal is to complete X% of assignments within a specified time frame. My report needs to show individual progress as well as team progress.
My main report is bound to my staff table. It is grouped by employee ID#.
In the detail for the employee ID# group, I have a subreport ([StaffSubreport])which is bound to my assignments table. The subreport and main report are linked by the employee ID#. In the report footer of the subreport, I have two fields: txtCompleteCount and txtPendingCount.
This results in my subreport displaying once for each employee.... in total it displays 12 times.
In my report footer, I have a control with this code, which returns the count from the last subreport displayed:
What I want is code that will display the total count from all the times the subreport was displayed. I've googled and googled and can't find this anywhere!Code:=[StaffSubreport].[Report]![txtCompleteCount]
Hopefully my explanation of my report makes sense... it is hard to describe. Here's a visual representation of what it looks like in print preview if that helps.
Report Header
.... Employee ID# Header
........Employee ID# Detail
............Subreport "StaffSubreport"
............Complete/Incomplete Header
................Assignment Detail
............Complete/Incomplete Footer
.... Employee ID# Footer
.... Employee ID# Header
........Employee ID# Detail
............Subreport "StaffSubreport"
............Complete/Incomplete Header
................Assignment Detail
............Complete/Incomplete Footer
.... Employee ID# Footer
.... Employee ID# Header
........Employee ID# Detail
............Subreport "StaffSubreport"
............Complete/Incomplete Header
................Assignment Detail
............Complete/Incomplete Footer
.... Employee ID# Footer
(repeat Employee ID grouping several more times)
Report Footer
Reply With Quote
