| Alphabetical List of Products | 11 | 287 | 0 | 2 | Underlying query for Alphabetical List of Products report.
|
| Category Sales for 1997 | 2 | 337 | 0 | 1 | Totals product sales by category based on values returned by the Product Sales for 1995 query.
|
| Current Product List | 2 | 82 | 0 | 1 | Filters records in Products table; query returns only products that are not discontinued.
|
| Invoices | 26 | 1,158 | 0 | 6 | (Criteria) Record source for Invoice report. Based on six tables. Includes expressions that concatenate first and last employee name and that use the CCur function to calculate extended price.
|
| Order Details Extended | 7 | 533 | 0 | 2 | Record source for several forms and reports. Uses CCur function to compute the ExtendedPrice for each item ordered.
|
| Order Subtotals | 2 | 304 | 0 | 1 | Record source for other queries. Uses Sum and CCur functions to compute subtotal for each order.
|
| Orders Qry | 20 | 544 | 0 | 2 | Underlying query for the Orders form.
|
| Product Sales for 1997 | 4 | 720 | 1 | 4 | Record source for Category Sales for 1995 query. Uses Sum and CCur functions.
|
| Products Above Average Price | 2 | 308 | 0 | 1 | (Subquery) Returns products that have a unit price higher than the average.
|
| Products by Category | 5 | 413 | 0 | 2 | Underlying query for the Products by Category report.
|
| Quarterly Orders | 4 | 369 | 0 | 2 | Record source for Quarterly Orders form. Lists only customers who had orders in 1995.
|
| Ten Most Expensive Products | 2 | 334 | 0 | 1 | (Top Values) Returns 10 most expensive products. Specifies the number of highest values to return using the Top Values box on the toolbar.
|