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

Group By Totals Try it: Group by the Totals Go to the Query Tools Go to Design->Show/Hide-Totals     What do you see? Total: Group By Save your changes and test the query.   Run Your Query: When you run this query, you should see 36 records. There will be several Ratings for each Genre. For example, this illustration shows Comedy, Drama, and Family movies rated PG. Query Design Tools ->Design->Show/Hide ->Totals