Database Reference
In-Depth Information
The results datasheet will display the extracted information in the order of the fields in the
design grid.
3
Run the query.
7
The results show that the query is working correctly.
4
Save the query with the name
Order Details Extended
.
5
Switch to
Design
view. Then in the
OrderID
column, display the
Sort
list, and click
Ascending
.
Now in a new field in the design grid, let's use the Expression Builder to insert an
expression that computes the extended price by multiplying the unit price by the
quantity sold, minus any discount.