Add a Single Criteria

In this topic you learn how to add a single criteria to the query in order to limit the query results to a specified value.

In this example the query will display the employees whose highest education level is Doctorate (Academic). To do this you will use the "equal to" Condition Type.

Steps:

1. Click the Add Criteria button for HIGHEST_EDUC_LVL.

   Step 1

2. Click the drop-down arrow for *Condition Type and select the "equal to" option.

    

   Note: The "equal to" Condition Type finds data having a value that matches the specific value.

   Step 2

3. Note: The Expression 2 Type defaults to Constant when "equal to" is selected.

    

   Click the Select Constant From List button to access the list of education level types and define the desired constant.

   Step 3

4. Click the Select Constant link for "J" Doctorate (Academic).

   Step 4

5. Click the OK button.

   Step 5

6. Click the Criteria tab.

   Step 6

7. Note: The Criteria tab now indicates HIGHEST_EDUC_LVL = J

    

   Click the Run tab.

   Step 7

8. Note: The query results display only those employees (whose records you may access) with a highest education level of J-Doctorate (Academic).

   Step 8

This completes Add a Single Criteria.

Table of Contents  Start Topic