Adding and Editing Query Criteria

Adding and Editing Query Criteria

Selection of the Add Criterion button in the Define Query dialog box opens the Add Criterion dialog box, which is used to create a condition by which to limit the query . This button is only available when at least one table is included in the query definition. As criterion are added to the query definition, they are shown in the Criteria in Query list box.

Selection of the Edit Criterion button in the Define Query dialog box opens the Edit Criterion dialog box, which is used to modify a query criteria selected from the Criterion in Query list box.. This button is only available when a criterion has been selected from the Criterion in Query list box.

The Add Criterion and Edit Criterion dialog boxes contain the following options:

And / Or radio buttons: Select one of these options to indicate whether this specified criterion must be met (And) or may or may not be met (Or) relative to the prior criterion. These buttons will be grayed out if this is the first query in the list.

Note: When And and Or operators are mixed within a set of criteria, And takes precedence (i.e. is applied first) over Or.
Field: Select the column containing the item on which to limit the query from this list of all the columns in the tables included in the query (not just the columns in the Columns in Query list box).

Operator: Select one of the following conditions to apply to the selected query field:

equals

does not equal

is greater than

is greater than or equal to

is less than

is less than or equal to

Value: Enter the value that the specified field will be compared to using the previously specified Operator. The Values... button provides a list of each unique entry in the specified Field. You may select one of these available Values from the Select Value dialog box. This may be a time consuming process for a large table on remote database via a slow link.