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

More Total Options

Try it: Count by the Rating

Select the Rating field.

Change the Total By: Count

 

Select the Genre field.
Change the Total By: Group By

Move the Genre field to the first column.

Memo to self: queries read from left to right.

 

Run the query: review the results. What do you see? The field name says, "CountOfRating."  In this sample, there are 127 Dramas and 50 Family movies.

 

Save the query and close it.

Query Design Tools ->Design
 

 

  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