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

MACINTOSH

=
=========================================================

= SUMMARY =

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.

= MORE INFORMATION =

To find the desired records, change the field type to “numeric” by doing the following:


 * 1) Select the column containing the numbers for the selection.
 * 2) From the Format menu, choose Set Field Attributes.
 * 3) 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.