Vlookup in access

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
No columns in ACCESS (just fields), but DLookup function may be what you
want to use. It's described in VBA help files.
 
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".
 
Back
Top