Freight totals are computed in the query and not stored in underlying table.
Do you want to calculate data, such as viewing total freight by country, adding two fields together, or multiplying a price times a percentage increase?
You can use a "totals query" to perform several calculations, including averaging and counting the number of records that meet certain criteria.
You can also create calculated fields, which appear along with other fields in your database.
In both cases, the calculations are not stored in your database, which helps control its size and efficiency.
Click Next to continue reading this lesson on your own.