Count of Query Field

[depawl]

I have a list of clients in a query field and I want get a count of the number of unique clients. Some records have duplicate clients. Lets say there are a hundred records but only 50 unique clients. When I apply "unique values" in the query's properties, and then enter "Count" in the Sum field, it gives me a count of 100 not 50. When I remove the Sum field, it lists the unique values correctly (50).
Thanks.

 

[llkhoutx]

Include on the client field and the count field in your query, other fields in your query cause the count to be off.