Sorting a Query

To list the records in alphabetical order of house types set the Sort entry in the Type column to Ascending as shown in this query:

Amend the previous query to list the ID, Address Line 1 and Area of property:

• in postcode order
• in price order

It is best to sort data in a query not in the original table since a query and its sorting order can be saved and retrieved for later use. In the query the order and type of sorting can be easily controlled. For example, the following query can sort on vendor as the primary key and Date of Entry as the secondary field (priority is from the left).

Contents: Databases

Skill Check: Databases