Filter Tab, Query and View Designers

See Also

Specifies conditions for selecting records, such as specific values in a field or join conditions defining temporary relationships between tables. This tab determines the conditions listed in the WHERE clause of the SELECT - SQL command in the SQL window. The Filter tab appears in both the Query and View Designers.

Tab Options

Mover Box

Drag the mover box to move the selected item up or down within the grid.

Condition Button

Click the double-headed horizontal arrow to edit the selected filter.

Field Name

Specifies the first field of the join condition. When creating a new join condition, click the field to display a drop-down list of the available fields.

Not

Reverses the condition to exclude records matching the condition.

Criteria

Specifies the type of comparison. The comparison types are:

• Equal   Specifies that the fields have the same value.
  
  
• Like   Specifies that the field must include characters that match characters in the example text. (Customer.state Like O would match records from Ohio, Oklahoma, and Oregon.)
  
  
• Not Like   Specifies that the field must not include the characters in the example text. (Customer.state Not Like O would not match records from Ohio, Oklahoma, and Oregon.)
  
  
• Exactly Like(==)   Specifies that the field must match the example text, character for character.
  
  
• Not Exactly Like(Not ==)   Specifies that the field must not match the example text, character for character.
  
  
• Greater Than (>)   Specifies that the field must be the same or more than the value in the example text.
  
  
• Greater Than or Equal To (>=)   Specifies that the field must be more than the value in the example text.
  
  
• Less Than (<)   Specifies that the field must be less than the value in the example text.
  
  
• Less Than or Equal To (<=)   Specifies that the field must be the same or less than the value in the example text.
  
  
• Is NULL   Specifies that the field must contain a null value.
  
  
• Is Not NULL   Specifies that the field must not contain a null value.
  
  
• Between   Specifies that the field must be greater than or equal to the lower value and less than or equal to the higher value in the example text. The two values in the example text are comma-delineated. (Invoices.idate Between 05/10/97,05/12/97 would match records for the 10th, 11th, and 12th of May, 1997).
  
  
• Not Between   Specifies that the field must not be greater than or equal to the lower value, and not less than or equal to the higher value, in the example text. The two values in the example text are comma-delineated. (Invoices.idate Not Between 05/10/97,05/12/97 would not match records for the 10th, 11th, and 12th of May, 1997).
  
  
• In   Specifies that the field must match one of several comma-delineated examples in the example text.
  
  
• Not In   Specifies that the field must match one of several comma-delineated examples in the example text.

Example

Specifies the comparison criterion.

Case

Specifies whether to match the case (upper or lower) of the example in your condition.

Logical

Adds an AND or OR condition to the join condition list.

Insert button

Inserts a blank join condition above the selected condition.

Remove button

Removes the selected condition from the query.