Database Reference
In-Depth Information
TIP
If the entire expression isn't visible in the expression box, you can widen the
Expression Builder dialog box by dragging its left or right border.
15
In the
Expression Builder
dialog box, click
OK
to insert the expression into the
design grid.
16
Press
Enter
to complete the entry of the expression. Then widen the column so that
the entire expression is visible.
Access has assigned the label
Expr1
to the field. (This label is known as the
field alias
.)
Let's change the label to something more meaningful.
17
In the design grid, double-click
Expr1
, and then enter
ExtendedPrice
.
18
Run the query.
7
The orders are sorted by the OrderID field, and the extended price is calculated in the last field.
19
In the few records with discounts, verify that the query calculates the extended price
correctly.
CLEAN UP
Close the query, saving it when prompted. Keep the GardenCompany07
database open for use in later exercises.