Table( Can it find the next value as well as the previous?

[Robert Ameeti]

At 9:05 AM -0600, 2/20/08, David Thompson wrote:

>>Using the example from the docs:
>>
>>keyField	dataField
>>0	2.50
>>50	2.35
>>100	2.25

>If the key field continues the pattern in those first three records, 
>where each value is 50 more than the previous value, then you could 
>round up and down and do two lookups. int(95/50)*50 would give you
>50. (int(95/50)+1)*50 would give you 100. Your two lookups would 
>give you 2.35 and 2.25 respectively.

LOL. Unfortunately not. I just used easy numbers to show what I am 
trying to do. The actual numbers are all floating point. Any other 
ideas? :-)

-- 

<><><><><><><><><><><><><><><><><><>
Robert Ameeti

The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little.
            -- Joe Martin, Porterfield
<><><><><><><><><><><><><><><><><><>