Group By Totals

This option will combine the repeated Ratings.

 

Before You Begin: Return to Design View.

Go to Home->Views->View->Design View.

 

Still Before You Begin: Edit the Query

Delete the Movie Field.

There will be only two fields: Genre and Rating.

 

5. Try it: Edit the Select Query

Go to Query Tools ->Design->Show/Hide.

Click on Totals.

 

What Do You See? When you click on Totals the Query grid will show the Total Row.

The default is Group By.

 

Try This, Too: Add Criteria

Type the Rating Criteria: Is Not Null.

Type the Genre Criteria: Is Not Null.

 

This will return the movies that do have (Is Not Null) have a Rating or Genre in tblMovies.

 

Keep going...

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

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Use Group By