| Category Sales for 1995 | 9/13/1995 10:51:43 AM | 8/19/1996 12:26:46 PM | 2 | 199 | Totals product sales by category based on values returned by the Product Sales for 1995 query. |
| Current Product List | 9/13/1995 10:51:43 AM | 8/19/1996 12:30:14 PM | 2 | 176 | Filters records in Products table; query returns only products that are not discontinued. |
| Invoices | 9/13/1995 10:51:44 AM | 9/16/1996 6:36:28 PM | 26 | 997 | (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 | 9/13/1995 10:51:45 AM | 9/16/1996 6:24:55 PM | 7 | 385 | Record source for several forms and reports. Uses CCur function to compute the ExtendedPrice for each item ordered. |
| Order Subtotals | 9/13/1995 10:51:45 AM | 6/10/1996 6:13:37 PM | 2 | 171 | Record source for other queries. Uses Sum and CCur functions to compute subtotal for each order. |
| Product Sales for 1995 | 9/13/1995 10:51:45 AM | 9/16/1996 7:20:40 PM | 3 | 504 | Record source for Category Sales for 1995 query. Uses Sum and CCur functions. |
| Products Above Average Price | 9/13/1995 10:51:45 AM | 9/16/1996 6:42:24 PM | 2 | 183 | (Subquery) Returns products that have a unit price higher than the average. |
| Quarterly Orders | 9/13/1995 10:51:45 AM | 9/16/1996 6:38:40 PM | 4 | 240 | Record source for Quarterly Orders form. Lists only customers who had orders in 1995. |
| Sales by Category | 9/13/1995 10:51:46 AM | 9/16/1996 6:39:32 PM | 4 | 577 | Record source for Sales by Category report. |
| Ten Most Expensive Products | 9/13/1995 10:51:47 AM | 9/16/1996 6:44:30 PM | 2 | 146 | (Top Values) Returns 10 most expensive products. Specifies the number of highest values to return using the Top Values box on the toolbar. |