Edit Criteria

Select Edit from the Criteria menu to display the Edit Criteria dialog box. It is also displayed when you double-click a criteria displayed on the Criteria tab. Use these options when you want to edit a specific criteria.

And/Or. The And/Or option buttons are only available if you have already defined at least two criteria for the query. When And is selected, records must meet both the existing and the new criteria conditions (i.e. both of the criteria must be true) to be included in the cases that will be "returned as data." When Or is selected, records only have to meet one of the criteria conditions (i.e. either the existing or the new criteria must be true) to be "returned as data."

OK. Click this button to add the criteria that you have specified to your query. You will then see the criteria that you have defined displayed on the Criteria tab.

Cancel. Click this button to exit the Edit Criteria dialog box without changing the criteria.

Table. Use the Table drop-down list to select the appropriate table for your criteria. You can select from all of the tables that are currently in the Graphic pane.

Field. From the Field drop-down list, select the appropriate field for your criteria. Statistica Query will display all of the fields that belong to the specified Table (see above).

Operator. From the Operator drop-down list, select the appropriate operator for the criteria. In order for records to be "returned as data," the operator that is chosen in this field must be true for the specified Field and Value(s).

Value. Enter the value(s) for Statistica Query to use when selecting records that will be "returned as data" in the Value field. For a list of all of the values found in the specified Field, click the Values button.

Values. Click this button to display the Select Value(s) dialog box, which is used to select from the list of values found in the specified Field.