Query: Sort

You can Sort and Filter a Query, just as you would a Table. Here are the steps.


6. Try it: Sort the Records

The MovieSQ results are still open in datasheet view.

Select a Field: Year

Go to Home ->Sort & Filter.

Click on Descending.


What Do You See? The Records should be sorted by Year: descending means the newest movies will be on top.


The Wizard is a good way to get started.
Now, let's look at the Query Design.

Home ->Sort & Filter->Descending

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Use Sort and Show Options