9 Replies Latest reply on Oct 28, 2016 10:41 PM by BruceRobertson

    Sum the column field for all records

    kbrady@voventerprises.com

      Hey folks I have one table that has a field in it called Num_Landings. I also created another field called Total_Num_Landings. I would like to calculate this second field with the total number of landing from all records and not just the record Im on.

       

      num_landings
      total_num_landings
      313
      413
      113
      513

       

      The calculation on field (total_num_landings) should SUM all landings from num_landings

       

      I started off doing a ExecuteSQL - ExecuteSQL("select sum(num_landdings) from tbl_LogBook");

       

      I placed the field (total_num_landings) field on a form page but it's only grabbing the total_num_landings for the current record im on.