6 Create another calculated field in the first empty field
8 namedListComm that will calculate the listing agent ' s commission based on the sales price and a listing commission rate of3.5 % . Add a caption of Listing Commission and format the field as Currency .
7 Create another calculated field in the first empty field
8 namedSellComm that will calculate the listing agent ' s commission based on the sales price and a selling commission rate of2.5 % . Add a caption of Selling Commission and format the field as Currency .
8 Save the query and switch to Datasheet view . Add a
9
Total row . Calculate the average number 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
5
Summary by Last Name . Switch to Design view and remove the DateListed , SellingAgent , ListingAgent , and Subdivision fields .