Entering a formula in a database field

Calculation and summary fields include formulas to calculate values from other fields in the database. A formula can include the following items:
constants (fixed numbers)
values from other fields
arithmetic operators such as + and -
functions (instructions for mathematical, logical, or textual calculations)

To enter a formula in a calculation or summary field:
1 Choose Define Fields from the Layout menu.
2 Select a field in the list or define a new field, choose Calculation or Summary from the pop-up menu, and click Create.
If you're modifying a formula for an existing field, click Modify.
3 Build a formula by typing constants and selecting field names, operators, and functions.
4 Choose a type from the "Format result as" pop-up menu.

Related topics

  Defining and working with database fields
Summarizing database data
About functions

 
Table of contents Index