Sorting Records

graphics/microsoft91.gif

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

graphics/one_icon.jpg

In the Datasheet view, display the table, query results, form, or report in which you want to sort records.

graphics/two_icon.jpg

To sort multiple columns , rearrange them to be adjacent.

graphics/three_icon.jpg

Click the column selector of the column you want to sort. To select another column, press and hold Shift, and then click the column selector.

graphics/four_icon.jpg

Click the Sort Ascending button on the Table Datasheet toolbar (A to Z), or click the Sort Descending button on the Table Datasheet toolbar (Z to A).

graphics/13inf01.jpg

graphics/13inf02.jpg



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net