Selection criteria for views

To establish selection criteria for the rows, you will need to create a WHERE clause or a HAVING clause.

  1. To create the WHERE clause, click Select Rows.
  2. To create the HAVING clause, click Summary Rows.
  3. On the dialogs, click to select a column, operator , or function.
  4. Double-click to add the selection to the clause. The clause is constructed in the Clause box below.
  5. Click OK to return to the New View dialog.

You may now:

If you want to do none of these, click OK to create your new view.