3 Replies Latest reply on Mar 1, 2017 7:47 AM by philmodjunk

    Summary fields in Form View


      Hi all,


      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.