U.M. (Windows)

Creating a database file 2-13
Understanding formulas
You write a formula (a specific operation on one or more values in the
database) for a calculation or summary field. For example, suppose your
file contains two number fields—Unit Price and Quantity—and one
calculation field, Subtotal. You want to calculate a value for Subtotal in
each record, so you write the calculation formula:
Unit Price * Quantity
for the Subtotal field. Then, each time you type values in Unit Price and
Quantity, the formula multiplies those values and displays the result
in Subtotal.
Use a calculation field to calculate a result from values in other fields in
the current record (or from other related records, using a relationship).
Use a summary field to produce a result using values in more than one
record in the database.
Contains a formula that multiplies the value in
Unit Price by the value in Quantity
Contains a formula that multiplies the value in
Tax Rate by the value in Subtotal and adds
the result to Subtotal
Calculation fields
Summary fields