Tips for Sorting

You should define sorts so that data are sorted in the same order as the groups defined for the query or report. For example, you want to run a query that will list equipment units and you require a count of the number of units of each equipment class in each department.

Step 1.  Select department as the first group, because that is the highest level of organization of the data in the query (you want the query to include all equipment classes for every department).

Step 2.  Select equipment class as the second group, because you want a summary of all the equipment units in each class. Because the class group is below the department group, the query will give a separate summary for each class within each department.

Step 3.  Specify that data be sorted by department and then by equipment class. If you do not specify a sort that corresponds to the group definitions, the query or report may contain more than one section for the same group.