AnsweredAssumed Answered

Sorting...A better way??

Question asked by eekamouse on Aug 11, 2012
Latest reply on Aug 11, 2012 by Sorbsbuster


Sorting...A better way??


MAC FMP11 advanced

I am trying to sort 767,797 business leads by state and generate a report that displays the number of records in each state.


In the past I have had to create a number field (named "count" for example) for each record with a "1" in each instance of the field. Then create a summary field of "count" to use in my sub summary by state.


Is their a better way that does not require the extra field?


Thanks in advance