Use the Query Builder
 
 
 

To construct a query with multiple parameters on the Query Builder tab

  1. Enter the first parameter of your query as described in To construct a query with a single parameter on the Query Builder tab.
  2. Select the appropriate And or Or operator from the Logical field.

    Clicking in the Logical field inserts an And operator. Clicking the cell again changes the value to Or.

  3. Enter additional query parameters on subsequent rows of the Query grid.
  4. Repeat step 2 for each additional parameter except the final query parameter.
  5. Apply any parenthetical grouping, if appropriate. Click the cell to the left of the Field cell that begins the phrase that you want to group. A single left parenthesis is inserted. Click the cell to the right of the Value cell that ends the phrase that you want to group. A single right parenthesis is inserted.
  6. If you want to save the query in the current drawing for future use, click Store.
  7. Click Execute to execute the query and close the dialog box.