Count of individual cities

[David Pritchard]

My "city" field in my contact database obviously has many cities. After creating a found set of records, I want to be able to show the name of each city represented with the number of records that match each city. Such as Scottsbluff - 13 Gering - 7 Chadron - 9, etc.

How would I accomplish this?

Thanks!

David

[mr_vodka]

If you create a self join relationship using the city as the key, and then create a calculation field that uses a count function of the related self join records, then it will give you the number of records with the same city.

Count (SelfJoin::city)