When determining whether a number is inside a range, which logical operator is it best to use

Operator

Purpose

Example

+

Sum two numbers.

[Subtotal]+[SalesTax]

-

Find the difference between two numbers or indicate the negative value of a number.

[Price]-[Discount]

*

Multiply two numbers.

[Quantity]*[Price]

/

Divide the first number by the second number.

[Total]/[ItemCount]

\

Round both numbers to integers, divide the first number by the second number, and then truncate the result to an integer.

[Registered]\[Rooms]

Mod

Divide the first number by the second number, and then return only the remainder.

[Registered] Mod [Rooms]

^

Raise a number to the power of an exponent.

Number ^ Exponent

Operator

Purpose

Example

And

Returns True when Expr1 and Expr2 are true.

Expr1 And Expr2

Or

Returns True when either Expr1 or Expr2 is true.

Expr1 Or Expr2

Eqv

Returns True when both Expr1 and Expr2 are true, or when both Expr1 and Expr2 are false.

Expr1 Eqv Expr2

Not

Returns True when Expr is not true.

Not Expr

Xor

Returns True when either Expr1 is true or Expr2 is true, but not both.

Expr1 Xor Expr2

Operator

Purpose

Example

&

Combines two strings to form one string.

string1 & string2

+

Combines two strings to form one string and propagates null values (if one value is Null, the entire expression evaluates to Null).

string1 + string2

Operator

Purpose

Example

Is Null or Is Not Null

Determines whether a value is Null or Not Null.

Field1 Is Not Null

Like "pattern"

Matches string values by using the wildcard operators ? and *.

Field1 Like "instruct*"

Between val1 And val2

Determines whether a numeric or date value is found within a range.

Field1 Between 1 And 10- OR -

Field1 Between #07-01-07# And #12-31-07#

In(val1,val2...)

Determines whether a value is found within a set of values.

Field1 In ("red","green","blue")- OR -

Field1 In (1,5,7,9)