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