tbl_Lookup_Val_2Range

Purpose

Looks up two values that fall into two ranges. The Low and High parameters are 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(

<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.
)

Example

This example looks up two values that fall into two ranges, such as mileage pairs.

tbl_Lookup_Val_2Range

( "Custom Tables\001-0003\MILES.MDB"

, "MILES"

, "010"

, "014"

, "Low_Begin"

, "Low_End"

, "High_Begin"

, "High_End"

, "Miles"

, False

)

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.