troubleshooting Question

Display # of Emp in a Column Report displayed in footer of report

Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America asked on
Microsoft AccessMicrosoft Development
29 Comments1 Solution363 ViewsLast Modified:
I have created a report that uses columns for an ORG chart report.  I need to display the total number of employees within each column.  How do I incorporated this value so that it is displayed at the bottom of the report and not at the floating bottom of the column.

I also need to include a total of employees, broken down by the type of employee - ie a legend. to also be displayed on the bottom of the report.

Note: I have tried various approaches by including the count (ie.  Count(Empl#) places in the Manager footer - this gave me the floating value depending on the height of the column values.  Then I tried using this field as a hidden field and placing a text field in the Report footer that references that hidden field - but that failed.

Also tried using a subreport but I was unable to get the report to line up with the Manager's column in the main report.

Looking for any suggestions.1 - sample from the original spreadsheet - which I am attempting to create in an Access Report.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 29 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 29 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros