Access 2010

More table options

Calculated fields and totals rows

Adding calculated fields and totals rows to your table lets you perform calculations using your table data. A calculated field calculates data within one record, while a totals row performs a calculation on an entire field of data. Whenever you see a subtotal for one record, you are looking at a calculated field. Likewise, a grand total at the bottom of a table is really a totals row.

Example of a calculated field and totals row in a table of orders

To learn how to create calculated fields and totals rows, review our mini-lesson located in our Extras section on How to Create Calculated Fields and Totals Rows in Tables.