Add the SalePrice and Sold fields to the query (in that order) then Display the Total row (Show/Hide group of the Design tab). A new row labeled Total displays in the query design grid, between the Table and Sort rows. Each field has Group By listed in the new row by default.