% Microsoft Access
File Edit View Insert Format Records To ols Windo w Help
BNorthWind: Database
M Tables OfP Queries J Forms ]
[|p Auto L o okup OP [Catalog
EP Category List EP Category Sales for 1993 EP Customer List
OP Daily Order Totals Data Definition Query OP Employee List
[P Employee Sales by Country (Parameter) EP Employee Sales for 1993
EP Fig-8-l EP Freight Charge s EP Invoices
EP Order Details Extende EP Order Information EP Order Review EP Order Subtotals EP Pro duet List EP ProductNames and ID EP Products and Suppliers
jp OuervlH§elect Query
Category |
Iterns |
Avg_UP |
SumStock |
SurnOrdered | |
► |
li 12 |
$37.98 |
559 60 | ||
2 |
12 |
$23.06 |
507 |
170 | |
3 |
13 |
$25.16 |
386 |
180 | |
4 |
10 |
$28.73 |
393 |
140 | |
5 |
7 |
$20.25 |
308 |
90 | |
6 |
6 |
$54.01 |
165 |
0 | |
7 |
5 |
$32.37 |
100 |
20 | |
8 12 |
$20.68 |
701 120 |
Record: l< | < | |~~
1 ► | ► l | > | of 8
Same as Category ID in Categories table.
Reporls | 2 Macros |