لطفا منتظر باشید ...
Ordering Your Query Result
When you run a new query, notice that the query output appears in no particular order, but generally, you want to order it. You can do this by using the Sort row of the query design grid.To order your query result, follow these steps:
Figure 4.6. Changing the order of the query result.
 | To sort in ascending order by the ContactTitle field, follow these steps: |
Sorting by More than One Field
Quite often, you want to sort your query output by more than one field. The columns you want to sort must be placed in order from left to right on the query design grid, with the column you want to act as the primary sort on the far left and the secondary, tertiary, and any additional sorts following to the right. If you want the columns to appear in a different order in the query output, you must move them manually in Datasheet view after you run the query.
| Sort the query output by the Country field and, within individual country groupings, by the ContactTitle field. Because sorting always occurs from left to right, you must place the Country field before the ContactTitle field. Therefore, you must move the Country field. Follow these steps: |
