Unique record count

[sparky06413]

Hello,____I created a total count of a field called CLIENT and it accumulates by group. How can I create a count of unique clients?____Thanks for your help.

[kfleming]

If client is the firtst level group field and you are sorting and grouping by client, a grand total that accumulates once per client will give you a count of the number of unique clients in the report.____Kathleen__R&R Support

[Mark_(Guest)]

Hi Kathleen,____Thanks for the reply. I^m not grouping by client but by employee and my employee has a total of clients. If the employee services the same client more than once the overall count is correct but I would like an additional total of unique clients.____Mark

[kfleming]

Can you sort by client within employee? That would let you create a count that accumulates once per client and resets by employee.____Kathleen__R&R Support