Article Detail

Search Article Headers        
  Techniques used in Access for sorting records in a table
  Article Contents 
InformationInformationInformation / Instructions on how to perform the required tasks
1.1This article covers the techniques used in Access for sorting records in a table, query, form, report, or data access page.
2.1Move to the field on which you wish to sort by clicking directly into the Record or using the Tab Key
2.2Sort Ascending - When the Field has focus, click on the A-Z Button in the ToolbarToolbar_Sort_Ascending
2.3Sort Descending - When the Field has focus, click on the A-Z Button in the ToolbarToolbar_Sort_Descending
2.4An ascending sort displays values where the check box is selected at the top and values where the check box is cleared at the bottom. A descending sort does the opposite.
2.5Note that a distinction is made between records with null values and those records where the check box was explicitly cleared. When sorted in ascending order, records with null values appear before records with cleared check boxes.
3.1To sort on adjacent columns in a datasheet, select two or more adjacent columns at the same time, and click one of the sort buttons.Datasheet Sorting
3.2Access treats the leftmost column as the outermost sort column, the second right column as the inner sort column, and so on. For example, if you select the LastName and FirstName columns, and if the LastName column is to the left of the FirstName column, then, when you do an ascending sort, you will see the last names in ascending order, and within each last name, the first names will be listed in ascending order.
Related Articles
2.2 2.2
2.3 2.3
3.1 3.1
NameEstate Systems Ltd
Phone07773 372024
Article Type: ATLAS Application Manual  - ATLAS database support manual - based around individual forms (Help Reference Pages)
ID-14310 , Revised 01/07/2009 12:00:00 AM , Revision  1
Written by: Jonathan  Spratt (ES) , Estate Systems
Article Limited to: Estate Systems - Databases, Websites and Quality inc UKDS