Database Reference
In-Depth Information
6
In the
Field
row, right-click in the first blank column, and then click
Build
to open the
Expression Builder
dialog box.
In the Expression Builder dialog box, the Order Details Extended query is selected in the
Expression Elements box, and the Expression Categories box displays the fields from the query.
Here is the expression you are going to build in the expression box:
CCur([Order Details]![UnitPrice]*[Order Details]![Quantity]*
(1-[Order Details]![Discount]))
The CCur function converts the results of the math inside its parentheses to currency
format.
TIP
If you wanted to enter this expression directly into the field, you could simplify
it to this:
CCur([Order Details]![UnitPrice]*[Quantity]*(1-[Discount]))
The [Order Details]! part is required only for the UnitPrice field, which appears in both
tables. It tells the query which table to use.
7
In the
Expression Elements
list, double-click
Functions
, and then click
Built-In
Functions
.