Vlookup in access

[Chris]

Hi Folks,

I have a table with an 'attainment' column and
a 'numerical value' column. When an attainment value of
say 'P1' is entered I want the 'numerical value' column
to return a value based on another table
called 'tbllookup'. In Excel you use vlookup, how do I
achieve this in access?

Deeply grateful for any help anyone, its driving me mad.

Ta

Chris

 

[Ken Snell]

No columns in ACCESS (just fields), but DLookup function may be what you
want to use. It's described in VBA help files.

 

[Jeff Boyce]

Chris

In addition to Ken's suggestion, you could also use a query to return the
"numerical value" when you (or your application) provide a criterion value
for "attainment".