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:

1.

If necessary, display the Field Chooser.

2.

Click the New button to display the New Field dialog box (shown earlier in Figure 27.7).

3.

Enter a name for the new field in the Name box.

4.

Select Formula from the Type list.

5.

Click the Edit button to open the Formula Field dialog box (see Figure 27.10).

6.

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.

7.

Edit the formula, adding the standard mathematical operators + (addition), – (subtraction),

/ (division), and * (multiplication) to define the formula.

8.

If desired, click the Function button to select from the built-in functions for use in your

field formula.

9.

When finished, click OK.

FIGURE 27.10

Defining a formula field.