Tuesday, May 3, 2011

Calculated Fields - XI


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
Design View Button
  • In the Query Pane, right-click on the field where you would like to create the calculation
  • Click Build
Build Drop Down
  • 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
Expression Builder Dialog Box
  • Click Run
Run Button
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
Zoom Drop Down

No comments:

Post a Comment