Records order

Let us specify the order of report records.

1. Click the Order tab and specify that the query result is ordered by the value of the Revenue field (fig. 13.27).
   
   
   Fig. 13.27. Specifying the order of records in a query
   
   This completes the query creation.
2. Click OK.
   
   This returns you to the Data composition schema wizard.

Next page: Analyzing query text