Works: How to Sort on More than Three Fields (76864)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 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.

REFERENCES

For more information about how to perform this task in Works, see your Works printed documentation or online Help.
Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB76864
©2004 Microsoft Corporation. All rights reserved.