Office Connector Web Help | Online Help |
Condition Window |
Contents | Index |
FieldSelect the field on which you want to base the condition.ComparisonSelect the option to control how the field value is compared to the Compare To value. Most of the comparison operators are straightforward. Here are the notable exceptions:LikeLike allows you to use wildcards to perform pattern matching on text fields. For example, you could specify Name Like *Electric* to return all vendors that have the word "Electric" in their names.Like is not available for non-text fields, such as date and number types. The functionality of Like is restricted when working with workbook functions because of limitations imposed by Microsoft's filtering technology. For example, you can not create "ends with" patterns such as *Electric because a filter can not start with a wild card unless there is another wild card later in the pattern. A complete description of how to use the Like operator is beyond the scope of this help. Event 1 does offer training that includes the use of the Like operator in our Workshop class. Alternately, there are numerous tutorials available on the web. Not likeThis option is not available for workbook functions.As you might expect, Not like produces the exact opposite results that Like does, i.e. it excludes records that match the pattern. One ofThis option is not available for workbook functions.One of is handy when you want to concisely check against a list of possible values. Using One of is equivalent to using a series of conditions in an Or group, but much more intuitive and compact. When you select the One of operator, the Value Type must be Literal Value. Not one ofThis option is not available for workbook functions.Similar to the One of operator, the Not one of operator returns records only if the value is not in the list. Compare ToValue TypeThe value type specifies what kind of source will be providing the value.
ValueThe value is compared against the selected field.
See Also |