U.M. (Mac OS)

Creating a database file 2-21
4. In the Specify Calculation dialog box, define the formula.
To Do this
Add a field
reference
In the formula box, click where you want the field reference to
appear. In the list of field names, double-click a field name.
Add a
mathematical or
text operator
In the formula box, click where you want the operator to appear. In
the keypad, click an operator. (Quotation marks and parentheses
are copied to the formula as a pair, with the insertion point blinking
in the middle).
Add a comparison
or logical operator
In the formula box, click where you want the operator to appear.
For Operators, choose an operator from the list.
Add a constant
value
In the formula box, type the value. (See “Constants” on page 2-15.)
Add a function In the formula box, click where you want the function to appear.
From the functions list, double-click a function. (To see a category
of functions, for View, choose a category.) In the formula box,
replace the placeholder parameter with the value or expression you
want.
Calculate only if at least one
field in the formula has a value
Choose field references
Formula box
Select
operators
Select
functions
Choose a formula result type
Choose
indexing and
result storage
options
Make a field repeating
Relationship pop-up menu