AnsweredAssumed Answered

Help with count or calculation of records with entries in a pop up menu field

Question asked by mlopez911 on Apr 22, 2009
Latest reply on Apr 23, 2009 by Orlando

Title

Help with count or calculation of records with entries in a pop up menu field

Post

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.

Outcomes