Microsoft KB Archive/62342

Works: Using Text for a Formula in a Database

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

1.00 1.05 2.00

MS-DOS

= SUMMARY =

In a Works database, text can be entered as a formula in a field to automate inserting the same text for every record. For example, use the following procedure if almost everyone in the database lives in California:


 * 1) Create a field called STATE.
 * 2) Create any other fields.
 * 3) Type in =&quot;CA in the STATE field on the first record, or California, depending on the style wanted.
 * 4) Switch to List view.
 * 5) Start placing information in the other fields.

The STATE field will automatically insert “CA” every time information is entered into a field. If a different STATE needs to be inserted, go to that cell and type in the correct information. To remove the formula, go to one cell in that field and type in “=” (without the quotation marks) and press ENTER. The text will disappear from every cell in that field with that formula.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

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