Create a calculated field in the first empty field named DaysOnMarket that will calculate the 9 number of days each sold property was on the market when it sold. Add a caption of Days on Market 6 Create another calculated field in the first empty field named ListComm that will calculate the 8 listing agent's commission based on the sales price and a listing commission rate of 3.5% . Add a caption of Listing Commission and form at the field as Currency. Create another calculated field in the first empty field named SellComm that will calculate the 8 listing agent's commission based on the sales price and a selling commission rate of 2.5%% . Add a caption of Selling Commission and format the field as Currency. Save the query and switch to Datasheet view. Add a Total row. Calculate the average number 9 of days on the market and the sum for the SalePrice and the two commission fields. Save and close the query. 9 Create a copy of the Sales Report query named Sales Summary by Last Name . Switch to 5 Design view and remove the DateListed, SellingAgent, ListingAgent. and Subdivision fields. 10 Display the Total row in Design view. Group by LastName and change the DateSold field Total 9 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 Sales and format of the DaysOnMarket 9 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 query named Sales Summary by Subdivision . Open the query in Design view and replace the LastName field with the Subdivision field, ensuring the Total row is set to Group By Created On: 07/12/2019 Exp19_Access_ChoS_ML2 - Investment Properties 1.0