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.