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

Total Options

Try it: Count by the Rating

Select the Genre field.

Change the Total By: Count

 

Run the query: review the results.

What do you see? The field name says, "CountOfGenre." 

 

In this illustration, there are 40 G rated and 83 PG13 movies.

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

 

  Microsoft Access 2007 Exam 77-605 Topic: 4. Creating and modifying queries 

  4.2. Modify queries       

  4.2.6.   Create sum, average, min, max, and count queries : Count queries