Database Reference
In-Depth Information
Now let's add a new field that uses data from two fields in the Products table to
perform a calculation.
7
Switch to
Design
view.
8
In the
Field
row of the third column, enter
UnitPrice*UnitsInStock
, and press the
Enter
key.
9
Widen the third column so that its entire contents are displayed. Notice that the
expression you entered has changed to the following:
Expr1: [UnitPrice]*[UnitsInStock]
This expression will multiply the price of each product by the number of units in stock.
10
Double-click
Expr1
, and enter
Value of Inventory
as the expression's label.
7
11
Display the
Total
list for the third column, and then click
Sum
.
12
Save the query with the name
Product Analysis
.
13
Run the query, which returns the sum of all the values calculated by the expression.
14
Widen the columns of the results datasheet so that their entire contents are
displayed.
This query now summarizes the data in three ways.
CLEAN UP
Close the query, saving your layout changes. Keep the GardenCompany07
database open for use in later exercises.