The attached file Homes.accdb contains three data tables: Agents, Properties, and SubDivision. Create the following three queries:

A query named Sales Report. This query contains the following fields: LastName from Agents table; date listed, date sold, SalePrice, SellingAgent, and ListingAgent from Properties table; Subdivisions from SubDivision table; a calculated field named DaysOnMarket (by subtracting DateListed from DateSold); a calculated field named ListComm (the commissions for listing agents using commission rate of 3.5% of sale price); and a calculated field named SellComm (the commissions for selling agents using commission rate of 2.5% of sale price). Add criteria to the query to ensure the DateSold is not empty (in other words, properties that have not been sold). In Datasheet view, add the Total row, which calculates the average number of days on the market and the sum for the SalePrice and the two commission fields. Save the query.

A copy of the Sales Report query named Sales Summary by the Last Name. Remove the date listed, selling agent, ListingAgent, and Subdivision fields. Display the Total row. Group by LastName and change the DateSold field Total row to Where, so the condition carries over. Show the sum of SalesPrice, the average of days on market, and the sum of both ListComm and SellComm. Change the caption for the SalePrice field to TotalSales. Save the query.

A copy of the Sales Summary by Last Name query named Sales Summary by Subdivision. Add Subdivision field. Modify the query so the grouping is based on the Subdivision field, not LastName. Sort the query results so the fewest Days of Market is first and the most Days of Market is last. Limit the results to the top five rows. Save the query.