Administrator: Receipts (Start) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Calculate the Sum Try it: Find the Sum Total of the Prices Go to Query Design Tools and Select Totals. All Fields begin with: Group  By. Price Field: Sum. This will return the sum total of the rental prices for each receipt.   Try it: Find the Max, Min or Average The Total can be edited to calculate the Average, Maximum (Max), and Minimum (Min). First and Last will filter the results to show one record out of many.   What If These Are Not the Right Answers? The query may not return the results that you want based on two factors: which fields are grouped together, and which order (from left to right) you are reading the code.   The only way to learn is to play with the query: add and remove fields. Test your query. Review the results...try again!

Query Design Tools ->Design->Show/Hide ->Totals