Microsoft KB Archive/43524

Works: Numbering Records in a Database

PSS ID Number: Q43524 Article last modified on 06-10-1996

1.00 2.00

MACINTOSH

= SUMMARY =

Microsoft Works does not automatically number each record in a Database document. To simulate numbering each record in the database, do the following:

  Add a Numeric field called “Number” to the database.   Open a new Spreadsheet document.   In cell A1, enter the number “1”.   In cell A2, enter the following formula: =A1+1   Select as many cells down as there are records in the Database (for example, select A1 to A100 for a 100-record database).   Select the range of rows (in this example, A1 to A100).   From the Edit menu, choose Fill Down.   From the Edit menu, choose Copy. </li>  Activate the Database document. </li>  View the database in List mode. </li>  Click the first cell of the Number field. </li>  From the Edit menu, choose Paste. </li></ol>

Each record will be numbered in the “Number” field.

KBCategory: kbother KBSubcategory: macworkskb

Additional reference words: 1.00 2.00

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