Stay informed about any major changes. Click here to subscribe
About calculations in a view
You can perform many types of calculations in a query. For example,
you can calculate the sum or average of the values in one field, multiply
the values in two fields, or calculate the date three months from the
current date.
When you display the results of a calculation in a field, the results
aren't actually stored in the underlying table. Instead, the program executes
the calculation each time you run the query so that the results are always
based on the most current data in the database.
