What I need to so count the number of employees that had an accident and each
employee should have a separate report with the total of accident they have
had. And for the department it should count only the accidents in that
department not a all department. I use this expression and I am getting a
character for result what I mean is that I am getting the name of the Dept
and not the numeric number
=nz(DLookUp("Department","[qry Employee Accident]"),0)
=count([employeeID])

I hope I answer your question

--
LHEMA


"Duane Hookom" wrote:

Are you attempting to count the number of employees? What field needs to be
Sum()'d?

--
Duane Hookom
MS Access MVP

"LHEMA" wrote in message
...
I have been working on this for a while, I have restarted my database it
works fine. Now I need to get total for accident per employee and the
total
for accident per departments. This is what I have done thus far, I have
put a
footer on my report for each grouping employee total and dept total. This
is
the expression that I am using =Sum([Department]) and for employees
=Sum([EmployeeID]). Using this expression I get a mismatch data type. Any
help is appreciation.
--
LHEMA