1 Reply Latest reply on Aug 11, 2012 3:08 PM by Sorbsbuster

    Sorting...A better way??

    eekamouse

      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