Ms access calculated field in table

/en/access/designing-your-own-database/content/

Introduction

Calculated fields and totals rows let you perform calculations with the data in your tables.

Calculated fields perform calculations using data within one record, while totals rows perform a calculation on an entire field of data.

Calculated fields

When you create a calculated field, you are adding a new field in which every row contains a calculation involving other numerical fields in that row.

To do this, you must enter a mathematical expression, which is made up of field names in your table and mathematical symbols.

How to sum a calculated field in access query

You don't need to know too much about math or expression building to create a useful calculated field. In fact, you can write robust expressions using only grade-school math. For instance, you could:

• Use + to find the sum of the contents of two fields or to add a constant value (such as + 2 or + 5) to a field
• Use * to multiply the contents of two field
  how to do calculations in access table
  how to perform calculations in access