Microsoft KB Archive/76864

= Works: How to Sort on More than Three Fields =

Article ID: 76864

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q76864



SUMMARY
When you sort in a Spreadsheet or Database in Microsoft Works, you are limited to three fields.

If you want to sort on more than three fields, you must sort multiple times, three columns or fields at a time. Also, the fields will need to be sorted in reverse order of importance.



MORE INFORMATION
As an example of sorting more than three fields or columns, suppose you want to sort on four fields, Field1, Field2, Field3, and Field4, in that order. To do this, you would:


 * 1) Insert Field2, Field3, and Field4 in the first, second, and third sort fields, respectively, and execute the sort.
 * 2) Re-sort using Field1 in the first sort field and leaving the other sort fields blank.

This will have the effect of doing a four-field sort.

NOTE: For reporting purposes, there is still a limit of three sort fields that can be used as break fields.

