Sum function is not working for me

I have this report that is base on a query and what I want to do is total the
number of times a accident happens in a department along with the employee.
For example if Bob had 2 accident in the Road Dept and Bill had 3 the total
for the road depart should be 5 and the total for bob should be 2 and bill
should be 3. I am getting 5 for them all. Here is my expression: =sum([Part
of Body Affected:])+([employeeID#])....

parts of body affected - is the injury


Sheri

My guess is that you need Part of Body affected & Employee ID - using + will
add on the value of the employee ID field

Sheila

"Sheri" wrote:

I have this report that is base on a query and what I want to do is total the
number of times a accident happens in a department along with the employee.
For example if Bob had 2 accident in the Road Dept and Bill had 3 the total
for the road depart should be 5 and the total for bob should be 2 and bill
should be 3. I am getting 5 for them all. Here is my expression: =sum([Part
of Body Affected:])+([employeeID#])....

parts of body affected - is the injury


Sheri

Not understanding what you are saying....instead of =sum([part of body
affected]+employeeID# use..........=sum([part of body affected]&[employeeID#]
--
LHEMA


"Sheila D" wrote:

My guess is that you need Part of Body affected & Employee ID - using + will
add on the value of the employee ID field

Sheila

"Sheri" wrote:

I have this report that is base on a query and what I want to do is total the
number of times a accident happens in a department along with the employee.
For example if Bob had 2 accident in the Road Dept and Bill had 3 the total
for the road depart should be 5 and the total for bob should be 2 and bill
should be 3. I am getting 5 for them all. Here is my expression: =sum([Part
of Body Affected:])+([employeeID#])....

parts of body affected - is the injury


Sheri