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




Custom Search