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

    Summary fields in Form View

    dloader

      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.