Criteria page (SQL designer)

Topic group Related topics

In the SQL designer, the Criteria page allows you to specify selection criteria that the query will use to include only certain rows of data in the query results. Adding selection criteria to this page adds a WHERE clause to the query. The criteria can be either a simple expression, an SQL expression, or an exists clause.

The grid contains the selection criteria by which the query will exclude rows of data.

The drop-down list box specifies whether all, any, none, or not all of the criteria apply.

Deleting a row

After selecting the row to delete, right-click and choose Delete Row from the context menu.