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. |