O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Rules for Creating Calculations

The formulas you enter into your calculated text box use standard mathematical controls:

+Add
-Subtract
*Multiply
/Divide

All formulas begin with an equals sign (=), and all field names are in parentheses. Here are some examples:

To calculate a total price by multiplying the value in the Quantity field by the value in the Price field, enter =(Quantity)*(Price).

To calculate a 25% discount off the value in the Cost field, enter =(Cost)*.075.

To add the total of the values in three fields, enter (Field1)+(Field2)+(Field3).

More Room

If you run out of room in the text box when typing your formula press Shift+F2 to open a Zoom box, where there's more room.

In this lesson, you learned to customize your report by adding ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required