When you define criteria with this operator, you must use two values. For example, if you select "is between" in the Operator box, Microsoft Query searches the field for which you set the criteria for values that fall between the two values you specify. Only those records are selected for the result set.