ORDER BY Clause

In Microsoft Access, an ORDER BY clause sorts the displayed data on a specified field or fields in ascending or descending order. The use of an ORDER BY clause is equivalent to clicking Ascending or Descending in a Sort cell in the query design grid.