Using Between Criteria


In this topic you learn how to add a criteria to the query in order to limit the query results to data that falls between two specified values.

 

In this example the query will display the employees whose original hire date is between January 1, 2004 and July 31, 2004. To do this you will use the "between" Condition Type.


Steps:

  1. Click the Fields tab.

    Step 1

  2. Click the Add Criteria button.

    Step 2

  3. Click the drop-down arrow for *Condition Type and select the between option.

    Step 3

  4. Enter the desired information into the Date field.

     

    Enter "010104".

    Step 4

  5. Enter the desired information into the Date 2 field.

     

    Enter "073104".

    Step 5

  6. Click the OK button.

    Step 6

  7. Click the Criteria tab.

    Step 7

  8. Note: The Criteria tab indicates ORIG_HIRE_DT between 2004-01-01 and 2004-07-31.

     

    Click the Run tab.

    Step 8

  9. Note: In addition to the highest education level criteria established in the previous exercise, the query output now also reflects only those employees hired between 01/01/2004 and 07/31/2004.

    Step 9

This completes Using Between Criteria.

Table of Contents  Start Topic