Help with count or calculation of records with entries in a pop up menu field
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.