AnsweredAssumed Answered

Sorting...A better way??

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

Title

Sorting...A better way??

Post

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

eek

Outcomes