• Assuming you have <Field1> <Field2> and <Field3>, you can provide in a query the following: =<Field1.value>+<Field2.value>+<Field3.value> It really is pointless to have an actual fourth field that has the sums of the three, as it would be redundant information. A query behaves just like a table, so any manipulation can be handled very easily. In addition, having a fourth static field in a table with the values of a calculation based on the contents of the record would require you to run a process to update the fourth field each time any of the other three fields are changed. By using a Query instead, the calculation is automatically performed, and you know that the fourth field is always accurate.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy