calc or sum of pop up menu field

[mlopez911]

I have a FMP 8.5 DB for an annual car show. One of the fields is called "Division." The field setup is set to Pop-up Menu with values from a value list "division". The division are 20's, 30's, 40's, etc.

I am trying to create a report or script which will give me an update to date number of entries in each division. If I create a field such as "count 20's" and code it's type to 'summary', I can get a total count of the division entries, but can't break it down to specific divisions.

I have also tried to write a script. I have been able to write the script to print/show a report of all entries in each division, however as time goes on it will be necessary to be able to see just the # of entries in each division, and I haven't been successful if figuring this out.

Any help will be greatly appreciated.

[comment]

If I create a field such as "count 20's" and code it's type to 'summary', I can get a total count of the division entries, but can't break it down to specific divisions.

You only need ONE summary field that counts any field that cannot be empty, placed in a sub-summary part (when sorted by Division).