------------------------------------------------------------- Sorting into ascending alphabetical order by film name. ------------------------------------------------------------- SELECT film FROM Stars ORDER BY film or SELECT Stars.film FROM Stars ORDER BY Stars.film ------------------------------------------------------------- ------------------------------------------------------------- Using the Len() function to find Length of the film name. ------------------------------------------------------------- SELECT film FROM Stars ORDER BY Len(film) or SELECT Stars.film FROM Stars ORDER BY Len(Stars.film) or SELECT Stars.film FROM Stars ORDER BY Len([Stars]![film]) --------------------------------------------------------------- To sort into DESCending order, i.e. reverse order, use DESC --------------------------------------------------------------- SELECT film FROM Stars ORDER BY film DESC SELECT Stars.film FROM Stars ORDER BY Stars.film DESC --------------------------------------------------------------- Note that ascending order is the default order for sorting, so if the ORDER BY somefieldName does not specify DESC, then the order will be ASCending alphabetical or numerical order.