Filtering Results

To narrow the query result set using the Query Inspector:
 

1. Click on the Where Clause tab.
    

• If using the Delete object, go to Step 2
   

• If using the Insert object, go to "Add Tables and data fields"
   

2. Click in the check box to activate the clause.
    

3. In the Operand field, select the table
    

4. In the operator field, select an operator from the drop-down list.

5. In the Value field, either type in a value or choose a pre-defined value from the drop-down list.
    

6. To narrow the results further, click on the next checkbox and repeat Steps 3 through 5.
    

7. Click OK to close the SQL Wizard.

Next