Making a Database - 5 - Sorting Data

In the last step (single query) we produced a list of the students who walk to school like this:

Sometimes it is more useful to have the results in the order of a different field.  In this case, year group:

STEP 1 - OPEN THE DESIGN VIEW OF THE QUERY

1. Click on Queries, qryWalktoschool, Design. 

2. Click on the sort box of the field yeargroup. Choose Ascending.

3.  Click File, Save as and name the new query qryWalksortyeargroup.

4.  When you run this query the results are in ascending year group order.

 PRACTICE:  Change one of your own queries to sort in order.