Vlookup in XL seems to do what I want,but I cant find anything similar in Access.
As per the title,I need the query to select the nearest number from another table to that specified in the query.
The lookup table has (say) whole numbers,but the query may be looking for a range in between because it generates a % variation change in what it wants to lookup
Tks.
As per the title,I need the query to select the nearest number from another table to that specified in the query.
The lookup table has (say) whole numbers,but the query may be looking for a range in between because it generates a % variation change in what it wants to lookup
Tks.
