Microsoft KB Archive/60767

Works: Consecutive Numbering in the Database

PSS ID Number: Q60767 Article last modified on 10-16-1998

1.05 2.00 3.00

MS-DOS

=
========================================================= 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

The following are two methods for creating a sequentially numbered field in Works.

Method 1 (Works 2.0 and 3.0 only)

 * 1) Create a field in the Database to contain the number.
 * 2) From the List screen enter the starting number in the first record of the field.
 * 3) Select the number of records to be numbered.
 * 4) Use Edit Fill Series to sequentially number the records.

Method 2 (Works 1.00, 1.05, 2.0 and 3.0)
  Create a field in the Database to contain the number.   From the List screen enter the starting number in the first record of the field.   In the next record, enter the following equation: =fieldname+1 This equation takes the number in the previous cell (same field, previous record), and enters that number plus 1 in the current cell. Once the equation has been entered in one of the records, select the cells to be numbered and use Edit Fill Down to copy the formula to the other cells. 

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.