This dialog box provides a convenient interface for the user to create a filter expression. While expressions can be created by simply typing into the edit control at the top of this dialog, it is often easier to use the list boxes and buttons to complete this task. All the fields, values, operators, and functions which may be used in a filter are available by point and click in this dialog box.
To insert an expression, the user selects a field name, operator and field value. For example, Type of Coll = Rear end. Upon selecting the insert expression button, the dialog box prepares and adds text to the expression edit control. It does this by replacing spaces in field names and field values with underscores, and then placing parenthesis around the entire expression. If the expression is to be more complex, the user may again choose another field name, field value combination, as well as an and/or option. Again, by selecting insert expression, the text is added to the expression above.
In the event that the user needs to access field names or field values individually, such as to place in a function, the buttons insert value and insert field are available.
More: