skip navigation
Access 2016 Tutorials

Access 2016 Tutorials

Access 2016 Tutorials - Calculated Fields

 
 
 Querying a Database Access 2016 Main Menu Designing Forms   

A calculated field is a field that gets its information from the calculations performed on other fields.  You can build calculated fields in the Query screen by using the addition (+), subtraction (-), multiplication (*) and division (/) operators.

Expressions

Expressions a combination of functions, field names, numbers, text, and the operators listed above.

To build an expression to create a calculated field:

  • Open an existing query or start a new query
  • Click on the View Button
  • Click on Design View

  • In the Query Pane, right-click on the field where you would like to create the calculation
  • Click Build

 

  • Choose the tables that you wish to build the calculation from
  • Double-click the field that you want to include in the calculation
  • Click the operator that you wish to include in the calculation
  • Click the second field you wish to include in the calculation
  • Click OK

 

  • Click Run

Zoom

The Zoom Dialog Box allows you to view an entire expression at one time.  To view the Zoom Dialog Box:

  • In Design View, right click on the field you want to display
  • Click Zoom

 

 Querying a Database Access 2016 Main Menu Designing Forms