Suppose you’re designing a query, and you want to display the results of a calculation using other fields in the query.
(Thus the name ‘calculated field’.) You can easily create a calculated field in the query using an appropriately formatted expression.
For example, if you have a query that contains a Quantity field and a Unit Price field, you can multiply the two to create a calculated field for
Extended Price by using the following expression:
Extended Price: [Quantity] * [Unit Price]
Prefacing the expression with the text Extended Price: names the new column Extended Price. (Note: the colon following the words Extended Price is required by Access to know when the field name
stops and the calculation information begins.) Unlike Excel, you do not start writing an expression/formula with an equal sign (=).
In the Menagerie_Kennel database there are three queries that need a calculated field created in order to be complete. They are:
