August 2003
Beginner
368 pages
10h 49m
English
Creating a Query in Design View To sort a field in ascending or descending order
Open the table in Datasheet view.
Click anywhere in the column you want to sort, and then click the Sort Ascending or Sort Descending button.
To reverse the sort order, click the opposite Sort button.
To sort on more than one column of information, arrange the columns so that they are side-by-side in the order you want to sort them, select the columns, and then use the Sort buttons.
Filtering Information in a Table To filter a table by selection
Open the table in Datasheet view.
Click any instance of the selection by which you want to filter, and then click the Filter By Selection button.
Filtering Information in a Table To remove a ...
Read now
Unlock full access