Add Criteria

From the Criteria menu, select Add to display the Add Criteria dialog box. It is also displayed when you click a field in the Graphic pane and drag it onto the Criteria tab. Use the options in this dialog box to define the criteria that records must meet in order to be included in the cases that Statistica Query will return as data. For example, you can specify criteria to select only records that have a certain value (such as customers in Louisville) or a specific range of numbers (such as orders that are between $1,700 and $1,900). See Criteria for additional information.

And/Or. The And/Or option buttons are only available if you have already defined at least one 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.

Add. Click this button to add the criteria that you have specified (in the fields described below) to your query. You will then see the criteria that you have defined displayed on the Criteria tab.

Close. Click this button to close the Add Criteria dialog box.

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

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

Operator. From this 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. In this field, enter the value(s) for Statistica Query to use when selecting records that will be returned as data. 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, where you can select from the list of values found in the specified Field.