Query Wizard - Sort Criteria

Top  Previous  Next  

 

In the Query Wizard - Select Fields screen you chose the Fields for which data will be retrieved and displayed by your Query.  The Query Wizard - Sort Criteria screen lets you choose the fields by which you wish to sort the data your Query retrieves.  The fields you choose to sort the data by, do not have to be field you have selected to display.

 

As with the Select Fields screen, Filtering of the lists and viewing of data are available.

clip5852

As with the Query Wizard - Select Fields screen, you select Fields in the Available list, and then you can change the order of, or deselect the Fields in the Selected list.

 

The order of your Selected fields is very important.  The records will first be sorted into groups by the first field in the list.  Each group of records will then be sorted by the next field selected, and so on.

 

You can change the sorting order on each of the Fields you have selected.  Click on the Field in the Selected List, and then click on the 'Ascending' check box.  If the check box is checked then the data will assort in ascending order (eg 1 - 10). if the check box is unchecked the data will sort in descending or (eg 10 - 1).

Once you have defined your Sort Criteria click 'Next >' to move to the next screen, Query Wizard - Add Multiple Subjects to Query.

 

 


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0