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




Custom Search