Changing the Sort Order

Queries read from left to right. Our query asks, “Which Movie?” then “What Year?” Here is a way to sort by the year, first.

 

1. Move the Column

Go to View->Design View

Select the Year column by clicking on the small column header above the field name, the same as selecting a column in Excel.

 

Move the Year left, before the Movie column.

 

2. Change the Sorting

Look at the bottom grid. The first row is for field names. The second row tells which table has the data. The third row is for sorting.

 

Select the Movie field

Select Sort -> Ascending.

Run your query

 

Now the query shows the latest releases on top, with the titles sorted by year. The movies that have no date are sorted on top. Microsoft displays no data (null value) first.