Microsoft Office Tutorials and References
In Depth Information
When the formula is complete, click OK to return to the New Field dialog box, which now
displays the formula in the Formula box. Click OK to close the New Field dialog box and the new
combination field is available, as a user-defined field, in the Field Chooser. You use it on your
forms like any other field.
Using Formula Fields
A formula field displays the result of a calculation using data in other fields. This kind of field is
usually used to work with numbers, but it can also perform operations on text data that are more
complex than simply combining fields as with a combination field. For example, suppose you are
designing an order form that already has fields for OrderTotal and SalesTaxRate. You could define a
formula field that calculates the sales tax amount by multiplying these two fields together.
To define a formula field:
If necessary, display the Field Chooser.
Click the New button to display the New Field dialog box (shown earlier in Figure 27.7).
Enter a name for the new field in the Name box.
Select Formula from the Type list.
Click the Edit button to open the Formula Field dialog box (see Figure 27.10).
Click the Field button to select each field that you want to use in the formula. Each field
name is entered into the Formula box enclosed in brackets.
Edit the formula, adding the standard mathematical operators + (addition), – (subtraction),
/ (division), and * (multiplication) to define the formula.
If desired, click the Function button to select from the built-in functions for use in your
When finished, click OK.
Defining a formula field.