Access 2003: Creating a Calculated Field

Access 2003: Creating a Calculated Field

Calculated fields are convenient when you want to display a formula result on your query. And, since proper table design dictates that you don’t add calculated fields to a table because they are prime for user input errors, the perfect place for them is in a query and they’re as easy as creating a formula.

To help you with calculated fields, here are a few reminders:

Start each [removed]or, calculation) with the name of the calculated field followed by a colon (:). For example: “TotalPrice:”.

Surround field names with square brackets. For example: [UnitPrice] or [EmployeeName].

You can open the Zoom box to see all of your expression at one time by pressing [SHIFT]+[F2].