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.
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.