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

    Sorting...A better way??



      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