AnsweredAssumed Answered

Sorting to Get the Summary

Question asked by jbrown Expert on Jul 28, 2012
Latest reply on Jul 28, 2012 by steve_ssh

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?

 

Thanks

jb

Outcomes