please forgive this basic question:
My database will be queried by users via the Form view (it will be read only). It shows 1 student at a time and it brings in their exam scores from related tables.
When I create a Summary field (with appropriate Average settings) and insert it in the Form view, I was expecting to see the Average from the Found records, but of course it just displays the Average from the one record being viewed.
So I anticipate that my best option is to use a calculation field?
What I require is the Average displayed from the sorted records (ie after a find).
Thanks for reading.