Use this function to set a simple filter on a field, such as a single range or a single value.

FieldRef.SETRANGE([FromValue] [, ToValue])

Parameters

FieldRef

Type: fieldref

The fieldref that refers to the field that you want to place a filter on.

FromValue

Type: any

The lower limit of the range. The data type of FromValue must match the data type of the field referred to by the fieldref.

ToValue

Type: any

The upper limit of the range. If you omit this parameter, the FromValue you specified is used. The data type of ToValue must match the data type of the field referred to by the FieldRef.

Expand imageRemarks

Expand imageSee Also