Between

Working with 13-Review and Reporting > 13-3 Report Writer > Calculated Fields > Between

Between

The Between operator defines a range of numbers similar to using to >= and <=. The range is inclusive of the two numbers you indicate.

Syntax: Between number1 and number2

Number1 is the low number.
Number2 is the high number.
Example: When you set the range between 5 and 10, the query searches for the numbers 5, 6, 7, 8, 9, and 10.

Links to more information . . .

Inner join

About Structured Query Language

More resources

For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.

For additional training on Sage products, visit Sage University.