10 Display the Total row in Design view . Group by
9
LastName and change the DateSold field Total row to Where . Show the sum of SalePrice , the average of DaysOnMarket , and the sum for both ListComm and SellComm .
11 Change the caption for the SalePrice field to Total
9
Sales and format of the DaysOnMarket field as Fixed . Run the query . Adjust column widths as necessary . Adjust the Total row in the Datasheet view so it shows the sum of Total Sales . Save and close the query .
12 Create a copy of the Sales Summary by Last Name
8 query named Sales Summary by Subdivision . Modify the query by replacing the LastName field with the Subdivision field . The grouping should be based on the Subdivision field .
13 Sort the query results so the fewest Days on Market is
9 first and the most Days on Market is last . Limit the results to the top five rows .