Summary Help (probably easy)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table containg names and hours:
|Name| |Sick| |Vacation| |Holiday| - etc....
The name field is related to another table with their manager name.

Is it possible to summarize everything per manager and his/her employees?
Right now i'm getting the manager name for each different employee all
listed out.
So let's say manager 1 has 5 people under him and manager 2 has 10.
All I need is a report to say
Manager 1 - |Sick| |Vacation| |Holiday| (for all the employees under him)
Manager 2 - |Sick| |Vacation| |Holiday| (for the employees under him)

Am I able to do this with the relation in another table, or do I need to
have the manager name in each row on the main table it's getting all the info
from?

Thanks!
 
Hi Jeffshex
Have you looked into grouping? You can put the Manager in a group header and
in detail section have all his emploees.

Hope it helps
Barb
 
yeah, but it wants to lists all the employees entries instead of just adding
them all up. I'm curious to see if that's because the table it's sorting
doesn't contain the managers name...it's just a relationship from the
employee name to a Staff Listing table that has the managers name.
 
Hi Jeffshex
you need to work In that group header or footer where you have manager's
name. Add textboxes for each column you need to add up. Use Count or Sum in
your formulas (Count for number of employees, Sum for Sum Vacaction
Days).Detail section where you have all these people listed should be hidden
( check into Detail properties)
That should do it.

Barb
 
It's odd, I get the managers name multiple times in the header, i have the
details hidden, but it puts the managers name each time in the header for
each different employee under them.
 
Hi Jeffshex.
Looks like you grouped it on Employee field, not manager field. You're very
close.Review your grouping, I'm sure you'll find a problem in there. I'll
check in here in 4 hours, after that I'm gone for a week. If you get really
frustrated (trust me I've been there) try creating a report with a wizard
(you may need a query to base it on - also easy with wizards), it would only
need a minior changes after the wizard creates it.

Good luck
Barb
 
I figured it out. Since there were 2 tables involved in putting this report
together I was having 2 choices on grouping. It automatically chose manager
grouping off the staff table...causing it to list the manager name summary
for each employee. Is what i did was changed the table to group off my main
table and then selected manager out of that area for the grouping.

What a pain. You better check your messages when you get back in town. I'm
sure I'll be trying to do plenty more here. ;)

Thanks for your help!
 
Anytime
I'm glad you've worked it out. I know how frustrating it can be when you're
close to the answer, but you can't really put your finger on it. Have a good
summer.
Barb
 
Back
Top