I'm stuck can not get total sum correct
I have added 10 more records and the expression is use for deparment:
=Count([Department]) and employee: =Count([EmployeeID]) and the results
that i am getting is 1 for everybody
--
LHEMA
"LHEMA" wrote:
ok..I will let you know the results
--
LHEMA
"Duane Hookom" wrote:
Why don't you take the time to type in about 10-12 records to show us
exactly what you want in your report. This would save a whole lot of
guessing and only take you about a minute.
--
Duane Hookom
MS Access MVP
"LHEMA" wrote in message
...
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
|