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.