Counting in a report

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

Guest

I have a report that is grouped by employees with costs associated to each
employee. I am trying to count the number of employees in the report footer
but =count([EMPLOYEE]) is counting all the records not just the number of
groups which would be what I want. The label and the name for this box is
the same.
 
Sort and Group by EMPLOYEE and show the Group Header section. Add a text box
to the section:
Name: txtCountEmp
Control Source: =1
Running Sum: Over All
Visible: No
Add a text box to the report footer:
Control Source: =txtCountEmp
 
Back
Top