Summary field in Access Report

[rogihead]

I'm having a problem with a count of the distinct names in a listing. What I have is a report that lists sales by location and I need to get a count of the distinct names of patients in each location. The way it is working now is that it counts each record but that does not give me the number of patients. I tried to alter the record count formula but I have been unsuccessfula t doing so. I believe that it has to do with the * in the record count formula but I am not sure what to change it to. This formula looks like this now:
="Summary for " & "PATIENT:" & " " & [CUSTOMER NAME] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")" but the field that I want to total is the CUSTOMER NAME field but only for distinct names.

 

[Crowley16]

set up a group for customers, and then outside of that group, put a control which containg: =count(fields)

--------------------
Procrastinate Now!

 

[rogihead]

I have tried this by creating a Customer Name group using sorting and grouping. I then placed the following in the control for an unbound text box "=Count([CUSTOMER NAME])" in the location footer and it gives me the total number of records, once again, not the number of patients within that Location grouping.