Selection criteria for views
To establish selection criteria for the rows, you will need to create a WHERE clause or a HAVING clause.
- To create the WHERE clause, click Select Rows.
- To create the HAVING clause, click Summary Rows.
- On the dialogs, click to select a column, operator , or function.
- Double-click to add the selection to the clause. The clause is constructed in the Clause box below.
- Click OK to return to the New View dialog.
You may now:
- View or edit the SQL used to create the view
- Create a formula from two or more of the columns
If you want to do none of these, click OK to create your new view.