Database Reference
In-Depth Information
8
In the
Expression Categories
list, click
Conversion
. Then in the
Expression Values
list,
double-click
CCur
.
7
The <<expression>> inside the parentheses represents the expressions that will eventually
result in the number Access should convert to currency format.
9
In the expression box, click
<<e x p r e s s i o n>>
to select it, so that the next thing you
enter will replace it. (The next expression element is the UnitPrice field from the
Order Details table.)
10
In the
Expression Elements
list, click the minus icon to the left of
Functions
to
collapse that element. Then click the plus icon to the left of
GardenCompany07.
accdb
(or your version of that fileāours is
MyGardenCompany07
), double-click
Tables
, and click
Order Details
.
11
In the
Expression Categories
list, double-click
UnitPrice
to replace the
<<e x p r e s s i o n>>
placeholder with the table/field information.
Now let's multiply the amount in the UnitPrice field by the amount in the Quantity
field.
12
With the cursor after
[UnitPrice]
in the expression box, click
Operators
in the
Expression Elements
list; click
Arithmetic
in the
Expression Categories
list; and
double-click
*
(multiply) in the
Expression Values
list.