Interpolating in Ms Access

[JOHROC]

Hello,

I wonder how can I get an access query to interpole kind of like in the VLOOKUP Excel formula.

I have a table that have a field named GAP that shows the distance between tow measures.
I have another table with 3 columns min, max and GAP_RANGE.

I want the query to identify in which gap range falls the GAP for each line.

Thank you in advance for your kind help

John

 

[SydneyGeek]

Allen Browne has created a function called ELOOKUP that does pretty well what VLOOKUP does, but in Access. Check it out here...

Denis