|
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 |
|
| |
