In the Show Table dialog box, double-click Inventory to add the field list window to table’s the design grid. Click Close. In the Inventory field list, double-click Year, Make, Model, Mileage, AskingPrice, and TradeInValue to add them to the design grid. On the DESIGN tab, in the Results group, click Run. On the HOME tab, in the Records group, click the Totals button. Scroll down, if necessary, to see the Total row at the bottom of the result set. In the Total cell of the Year field, click the down arrow to display the menu and click Count, as shown in Figure 12-50 in the MOAC on page 380. Notice the cell displays 26, denoting 26 values (years) in the Year column. Click the down arrow in the Total cell of the Mileage field and click Average. Click the down arrow in the Total cell of the AskingPrice field and click Maximum. Click the down arrow in the Total cell of the TradeInValue field and click Sum. Your Total row should appear similar to Figure 12-51 in the MOAC on page 381. Switch to Design view and remove the Model, Mileage, AskingPrice, and TradeInValue fields from the design grid. The Year and Make fields should be the only ones remaining on the grid. On the DESIGN tab, in the Show/Hide group, click the Totals button. A new Totals row should appear below the Table row on the design grid. Click the Group By cell below the Make field cell and click the down arrow to display the aggregate function menu. Click the Count aggregate function to select it from the menu, as shown in Figure 12-52 in the MOAC on page 382. Switch to Datasheet view. Your screen should resemble Figure 12-53 in the MOAC on page 383. Notice the records in the Make field are grouped by Year and counted with the results appearing in a new column named CountOfMake. Also notice the Year field is grouped and each year remains counted as applied from the aggregate function we created previously in Datasheet view. SAVE the query as Aggregated Query and CLOSE it. CLOSE the database. PAUSE. CLOSE Access.
In the Show Table dialog box, double-click Inventory to add the table’s field list window to the design grid. Click Close. In the Inventory field list, double-click Year, Make, Model, Mileage, AskingPrice, and TradeInValue to add them to the design grid. On the DESIGN tab, in the Results group, click Run. On the HOME tab, in the Records group, click the Totals button. Scroll down, if necessary, to see the Total row at the bottom of the result set. In the Total cell of the Year field, click the down arrow to display the menu and click Count, as shown in Figure 12-50 in the MOAC on page 380. Notice the cell displays 26, denoting 26 values (years) in the Year column. Click the down arrow in the Total cell of the Mileage field and click Average. Click the down arrow in the Total cell of the AskingPrice field and click Maximum. Click the down arrow in the Total cell of the TradeInValue field and click Sum. Your Total row should appear similar to Figure 12-51 in the MOAC on page 381. Switch to Design view and remove the Model, Mileage, AskingPrice, and TradeInValue fields from the design grid. The Year and Make fields should be the only ones remaining on the grid. On the DESIGN tab, in the Show/Hide group, click the Totals button. A new Totals row should appear below the Table row on the design grid. Click the Group By cell below the Make field cell and click the down arrow to display the aggregate function menu. Click the Count aggregate function to select it from the menu, as shown in Figure 12-52 in the MOAC on page 382. Switch to Datasheet view. Your screen should resemble Figure 12-53 in the MOAC on page 383. Notice the records in the Make field are grouped by Year and counted with the results appearing in a new column named CountOfMake. Also notice the Year field is grouped and each year remains counted as applied from the aggregate function we created previously in Datasheet view. SAVE the query as Aggregated Query and CLOSE it. CLOSE the database. PAUSE. CLOSE Access.