I am learning BASE and would like help with the following. I have four fields which record a thickness reading to two decimal places. The fifth field will need to calculate the average reading of fields one to four by adding them up and dividing by four and displaying the result in field 5. Can you point me to where I can find information on this or give some assistance. Thank you for your time and response.
Hello,
This information is typically generated by using SQL to create a total based upon already entered information. An example statement would be:
Select "MyID", ("Amt1" + "Amt2" + "Amt3" + "Amt4") / 4 As "Avg Result" From "MyTable"
You can use this result in a subform field where the record relates back to the form using the MyID field.
A working sample of this is in my answer on this post → Directions on setting up a form with some sub forms/tables….
Although the sample there used a SUM function in the SQL, the concept is the same.