Microsoft KB Archive/63533

Works: Cannot Sort or Print the Record Numbers in a Database

PSS ID Number: Q63533 Article last modified on 06-12-1996

1.00 1.05 2.00

MS-DOS

= SUMMARY =

Record numbers in a Microsoft Works database do not print and cannot be sorted or queried upon. A workaround is to create a record number field for sorting or printing record numbers in the database. If desired, this number field can subsequently be hidden in the List view by setting the field width to 0 (zero).

To create a new field, do the following:


 * 1) Open the database.
 * 2) From the View menu, choose List.
 * 3) From the Edit menu, choose Insert Record/Field, and select Field in the option box.
 * 4) From the Edit menu, choose Field Name, and type in a name (for example, “Number”).
 * 5) From record line 1 in the “Number” field, type a “1” (without the quotation marks) and press ENTER.
 * 6) Highlight, or select using the F8 key, all of the cells that will have a record number in them. Be sure to begin with the cursor on the 1 field.
 * 7) From the Edit menu, choose Fill Series, and select Number in the Units option box. This command will insert numbers consecutively down the field.

Sorting and printing the “Number” field can now be done in the same way as for all other fields.

KBCategory: kbprint KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.