Query Property Sheet Where Tab

This tab lists the expressions in the WHERE clause, which restrict the data retrieved by the query.

You can add or delete expressions as appropriate, and reorder the expressions in the list using the arrows at the bottom of the tab. Any changes you make will propagate to the query's SQL tab and to the SQL Query tab of the parent view.

  1. Click in the first empty row in the list.
  2. [optional] Enter a prefix in the Prefix column.
  3. In the first Expression column, select a column from the list. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.
  4. In the Operator column, select an operator from the list.
  5. In the second Expression column, select a column from the list. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.
  6. [optional] Enter a suffix in the Suffix column.
Parent topic: Working with View Queries