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.
Search WWH ::




Custom Search