Counting

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

Guest

Hi

I have a query that tells me how many times an Employee has attended a training session. It works, it give me all of the session per employee. Now in the report I want to show how many employees are all together. So the report should be like this

Name Session Times Attende
Maritza Osha
Max Health

Total Employes Attended =

I am not getting the 2 because when I do the count it tells me that it = 11 because its counting each one of the attending session. Does this makes sense. Please let me know if I should do it different

Thanks

Maritza.
 
Hi,

I have a query that tells me how many times an Employee has attended a training session. It works, it give me all of the session per employee. Now in the report I want to show how many employees are all together. So the report should be like this:

Name Session Times Attended
Maritza Osha 5
Max Health 6


Total Employes Attended = 2

I am not getting the 2 because when I do the count it tells me that it = 11 because its counting each one of the attending session. Does this makes sense. Please let me know if I should do it different.

Thanks,

Maritza.
Click to expand...

If each employee is shown just once in the report section, add an
unbound control to the section.
Set it's control source to
=1
Set it's running sum property to either
Over All or Over Group (whichever is appropriate).
Name this control "EmpCounter"
You can place it to the left of the Name field and it will print like
this:
1 Maritza OSHA 5
2 Max Health 6

Or you can make it not visible and add another unbound control where
you wish to show the total Employee count. Set it's control source
to:
=[EmpCounter]
 
Back
Top