In my school database, the principal needs to see the count of kids in each of the 12-16 classes being taught in each of the 6 periods. On a layout based on the enrollment table, I have just the summary fields showing such the counts, but it takes at least 1 minute to sort all 2200 records in order to activate the sub-summary rows and get the count.
Is there a better, faster way to get the count, without having the principal press sort then go get a cup of coffee while waiting?
Does the Get Summary function help in this aspect?
Show I create a server-side script that sorts the info, then populates it in static fields in the school table, this script to be run each night?