Sum function is not working for me

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

Guest

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
 
Not understanding what you are saying....instead of =sum([part of body
affected]+employeeID# use..........=sum([part of body affected]&[employeeID#]
--
LHEMA


Sheila D said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top