ערוך

שתף באמצעות


BETWEEN (Access custom web app)

Specifies a range to test.

Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Syntax

test_expression [ NOT ] BETWEEN begin_expression AND end_expression

The Between operator contains the following arguments.

Argument Required Description
test_expression
Yes
The expression to test for in the range defined by begin_expression and end_expression . Must be the same data type as both begin_expression and end_expression.
NOT
No
Specifies that the result of the predicate be negated.
begin_expression
Yes
A valid expression. Must be the same data type as both test_expression and end_expression.
end_expression
Yes
A valid expression. Must be the same data type as both test_expression and begin_expression .
AND
Yes
Indicates test_expression should be within the range indicated by begin_expression and end_expression.

Result Type

Boolean

Remarks

BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression.

NOT BETWEEN returns TRUE if the value of test_expression is less than the value of begin_expression or greater than the value of end_expression.

To specify an exclusive range, use the greater than (>) and less than operators (<).