Microsoft KB Archive/44635

Edit Find with Cells Containing Multiple Values

PSS ID Number: Q44635 Article last modified on 03-15-1995

1.00 3.00 3.00a 4.00 | 1.10 3.00 4.00

WINDOWS | MACINTOSH

When a field contains a list of values, such as the “Predecessor” field or the “Resource Names” field, the list of values in the “Values” field of Edit Find are compared to the values in the search field as if the values were one long string and not a list of many separate values.

Searches on these fields return the error message “No match.” The search values in the “Values” field must be an exact match for the values in the search field. In cases of cells containing multiple values, it is better to use a custom filter to find all those records matching the filter criteria.

KBCategory: kbother KBSubcategory:

= Additional reference words: 1.0 1.00 1.1 1.10 3.0 3.00 =

Copyright Microsoft Corporation 1995.