You can change the order in which records appear in a table, query results, forms, or reports by sorting the records. You can select a field and then sort the records by the values in that field in either ascending or descending order. Ascending order means that records appear in alphabetical order (for text fields), from most recent to later, (for date fields), or from smallest to largest (for numeric fields). In Descending order, the order is reversed . You might also want to sort records by more than one field; this is referred to as a secondary sort . For example, in a table containing information about products, you might need to view information about specific prices for each product. You can sort the records first by product and then, in records with the same product, sort the records by price. Sort Records
|