Step 2 Attach Selection Conditions to the Query

Step 2. Attach Selection Conditions to the Query

For the Sample Query, you want to retrieve the sales history for only some countries. To do this, you attach a selection condition to the Sales Country.

1.  Select the Options menu from the menu bar and choose the Field Conditions command. Alternatively, you could select the Field Conditions icon from the Tool Bar.

     The Field Conditions dialog box is opened.

     In the Field Conditions dialog box you can attach selection conditions to the fields in your query.

     The sample query already has a selection condition defined. In this case, all Countries except the US are selected. To edit a condition, highlight it, then re-select the Operators and Values.

     You can see that a field has a condition attached when there is an asterisk (*) to the left of the field's name in the Selected Fields area of the Query window. Do you see the asterisk next to Sales Country in this tutorial's Query window?

2.  Press the Cancel button to dismiss the Field Conditions dialog box.

     You are returned to the Query window.

3.  Go to Step 3. Execute the Query