Microsoft KB Archive/60071

Works: Entering Field Names Containing Commas or Hyphens

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

2.00 3.00

MS-DOS

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

= SUMMARY =

If a field includes a comma or hyphen (-) within its name, Microsoft Works for MS-DOS will enclose the name with single quotation marks. This does not represent field merging or concatenation; it is simply the way Works handles field names containing these characters.

= MORE INFORMATION =

Page 194 of the “Microsoft Works Reference” for Works 2.0 shows a database file, AWREPORT.WDB, which contains a field titled “City, State.” This field contains information on both the city and state of the persons listed in the database file. When this field name is entered in the report definition screen, Works surrounds the field name with single quotation marks because the field name contains a comma.

If you type “=City, State” (without the quotation marks) and press ENTER, the following field name will appear:

n=‘City, State’

This entry is not a concatenation of two text fields. It is not possible to concatenate two text fields in a report definition. If you have two separate text fields (one titled “City” and another titled “State”) and you attempt to enter them as described above, Works will generate the following error message:

Reference not valid or wrong operand type

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 2.00 merge combine errmsg =

Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.