Microsoft Office Tutorials and References
In Depth Information
Initial Expression Builder dialog box
You use the common operators and expression elements to help you build an expression.
Note that the HighWagesWithBonus query is already selected in the list box on the lower
left; the fields included in the original version of the query are listed in the center box.
The expression for the calculated field will multiply the Wage field values by the HoursPerWeek
field values, and then multiply that amount by the numeric constant .02 (which represents a
2% bonus). To include a field in the expression, you select the field and then click the Paste
button. To include a numeric constant, you simply type the constant in the expression.
2. Click Wage in the field list, and then click the Paste button. [Wage] appears in the
To include the multiplication operator in the expression, you click the asterisk ( * ) button.
Note that you do not include spaces between the elements in an expression.
3. Click the * button in the row of common operators, click HoursPerWeek in the field list,
and then click the Paste button. The expression multiplies the Wage values by the
4. Click the * button in the row of common operators, and then type .02 . You have finished
entering the expression. See Figure 3-34.
Completed expression for the calculated field
Note that you also could have typed the expression directly into the expression box,
instead of clicking the field names and the operator.