Microsoft KB Archive/44791
Mac Works: Record Selection Not Working for Range of Numbers
PSS ID Number: Q44791 Article last modified on 10-22-1998
1.0 1.1 2.0 3.0 4.0
|The information in this article applies to:|
|- Microsoft Works for the Macintosh, versions 1.x, 2.0, 3.0, and 4.0|
When you perform a record selection on a Microsoft Works Database field for a range of numbers, an unexpected range of numbers may be returned. For example, if the selection is set to be the range from 1 to 15, the only records returned may be those numbered 1, 10, 11, 12, 13, 14, and 15.
If the field upon which the selection is being performed is formatted as text, Works does a record selection on the text values based on the first character of the field for each record.
To find the desired records, change the field type to “numeric” by doing the following:
- Select the column containing the numbers for the selection.
- From the Format menu, choose Set Field Attributes.
- Select Numeric and choose the OK button.
KBCategory: kbother kbprb KBSubcategory: macworkskb
Additional reference words: 1.0 1.00 1.1 1.10 2.0 2.00 3.0 3.00 4.0 4.00 mwksdb ====================================================================== Version : 1.0 1.1 2.0 3.0 4.0 Platform : MACINTOSH Issue type : kbprb ============================================================================= Copyright Microsoft Corporation 1998.