## Range data types

Ranges are designed to handle a spectrum of values. Range types are available for all the simple types except for Boolean. That is: Number Range, Currency Range, String Range, Date Range, Time Range and DateTime Range. You can generate ranges using the To, _To, To_, _To_, Is >, Is >=, Is < and Is <= keywords. In general, To is used for ranges with 2 endpoints, and Is is used for open ended ranges (only one endpoint). The underscores are used to indicate whether or not the endpoints are in the range.

##### Examples of Number Range values

The range of numbers from 2 to 5 including both 2 and 5

    2 To 5

The range of numbers from 2 to 5, not including 2 but including 5

    2 _To 5

All numbers less than or equal to 5

    Is <= 5

All number less than 5

    Is < 5

##### Examples of DateTime Range values

    #Jan 5, 1999# To #Dec 12, 2000#
    Is >= #Jan 1, 2000#

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com