Vlookup in access

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

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

--

Ken Snell
MS ACCESS MVP

"Chris" wrote in message
...
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

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".

--
Good luck

Jeff Boyce
Access MVP