Add them all up

  • Thread starter Thread starter Nydia
  • Start date Start date
N

Nydia

I have a query that shows department name and a count of
how many union employees and how many management employees
there are, I created a report that looks something like
this

Human Resources
managemen 15
Union 20
Program Development
Management 10
Union 0

what i want to do is at the bottom of the report have a
total employees and for it to add up all the employees.
how do i do this?
 
Nydia,

Put a textbox control in the report footer and use the Sum()
function. If you control that is displaying the number of
employees is named "TotalEmployees" then you would use...

=Sum([TotalEmployees])

Gary Miller
Sisters, OR
 
Back
Top