tbl_Lookup_Val_2Range_1Dir

Purpose

Looks up two values that fall into two ranges in one direction (the Low and High parameters are not automatically reversed if they are out of order). This function has a specific application to rating for looking up mileage ranges.

Arguments

tbl_Lookup_Val_2Range_1Dir (

<filename>
//The MDB.
, <table name>
//The table name.
, <low_value>
//The low value.
, <high_value>
//The high value.
, <low_begin>
//The beginning value of the low range.
, <low_end>
//The ending value of the low range.
, <high_begin>
//The beginning value of the high range.
, <high_end>
//The ending value of the high range.
, <return_field>
//Field you want returned if there is a record in the range.
, <expand_flag>)
//If the expand flag is True, it will give you the return_field and it will tell you the actual range of low values and high values that were found in the table in list form.
)

Notes

<table name> parameter has been modified so that either a “Table_Name” “Table_Name:Index_Name” can be used. “Index_Name” is optional. If it is not given (as has been true to this point), then “PrimaryKey” is assumed.

<filename>	//The MDB.
, <table name>	//The table name.
, <low_value>	//The low value.
, <high_value>	//The high value.
, <low_begin>	//The beginning value of the low range.
, <low_end>	//The ending value of the low range.
, <high_begin>	//The beginning value of the high range.
, <high_end>	//The ending value of the high range.
, <return_field>	//Field you want returned if there is a record in the range.
, <expand_flag>)	//If the expand flag is True, it will give you the return_field and it will tell you the actual range of low values and high values that were found in the table in list form.