Newbies jdonahue Posted February 2, 2009 Newbies Share Posted February 2, 2009 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. Link to comment Share on other sites More sharing options...
bcooney Posted February 2, 2009 Share Posted February 2, 2009 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. Link to comment Share on other sites More sharing options...
Newbies jdonahue Posted February 3, 2009 Author Newbies Share Posted February 3, 2009 Thanks for the tip. It works perfectly now. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5555 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now