Counting in a report

[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.

 

[Duane Hookom]

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