need a vlookup

[buzzmcduffie]

I have a query that produces a "score" for each employee.

EmpID October Accuracy Score
ALS 100.00%
BKC 95.71%
CLJ 87.14%
CXP 95.71%
JTB 85.71%
JWS 91.43%
KMH 100.00%
LLW 70.00%

I have a lookup table (just a sample of the table)
score value
85.00% 2.34
86.00% 2.41
87.00% 2.48
88.00% 2.55
89.00% 2.62
90.00% 2.69

I need to associate the emp's score with a value in my lookup table.
If the score is 86.25%, I want the returning value to be 2.41.
In excel all I have to do is a vlookup. I'm sure I'm missing something.

thanks!

 

[Allen Browne]

DLookup() is the nearest equivalent in Access.

Here's an introduction to how it works:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

If you need to specify the sort order, this replacement might be useful:
ELookup() - an extended replacement for DLookup()
at:
http://allenbrowne.com/ser-42.html

If you really want to go to town this this, Tom Ellison's article is
informative:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html