February 2, 200916 yr Newbies I have a database listing contact names. I want to create a report that consists of all the cities listed in my database with a summary field displaying the total number of contacts in that city. I do not want to display each individual record in this report, only a list of cities with the corresponding count. I have been able to create a subsummary field with the contact count, but I cannot figure out how to list each city only once in the report. Any help would be appreciated.
February 2, 200916 yr The city field and summary field go in the sub-summary part and you sort by city. Do not have a body part on the report.
Create an account or sign in to comment