Statistics - Mode

[Gary1478]

Hi All:

I have a filemaker database of our customers. There are many duplicate companies but each has a separate contact. Each record also has a "CustomerSas" field which is a number field with a value the means something internally to our company. Is there a report I can run that will sort the duplicate companies and display the value in the "CustomerSas" field most often?

Any help is appreciated.

Gary

[Søren Dyhr]

This must be solved in the vicinity of this:

http://www.kevinfrank.com/download/classroom-averages.zip

--sd