AnsweredAssumed Answered

Sum the column field for all records

Question asked by kbrady@voventerprises.com on Oct 25, 2016
Latest reply on Oct 28, 2016 by BruceRobertson

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.

Outcomes