Summary Report

[jdonahue]

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.

[bcooney]

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.

[jdonahue]

Thanks for the tip. It works perfectly now.