Microsoft Office Tutorials and References
In Depth Information
Sorting datasheet rows
Sorting datasheet rows
Access is a very powerful tool for filtering and sorting your
data rows to show a subset of all available data. In Section 6,
“Selecting data using queries,” we will see how queries extend
the ideas described here to offer support for even more flexible
techniques.
With a datasheet, you can use the columns independently to
sort the rows. The sorting order is always read from left to right,
and sorting by multiple columns is supported.
1
2
Apply a sort on a column
1 Select the column.
2 Right-click the selected column, and on the shortcut menu, select
either Sort A To Z or Sort Z To A.
TIP The sorting order of fields is applied from left to right,
and fields for sorting do not need to be next to each other,
although this can make it easier to perform a sort on multiple fields.
1
Remove a sort
1 Click Remove Sort on the ribbon.
TIP The shortcut menu does not have an option to remove a
sort. When using the ribbon to remove the sort, you can see
that it also supports options to apply an Ascending (A to Z) or
Descending (Z to A) sort.
Search JabSto ::




Custom Search