Perform Vlookup function in access

[ritheshtitu1982]

Hi,

I would like to perform Vlookup in access.

Eg. I have two Tables

Code table
Code --- No
{ ------- 0
} ------- 1
A ------- 2
B ------- 3
C ------- 4
D ------- 5

( I have used this (----------) for clear understanding)
Sale Table
SaleCode SaleNo
}
A
A
{
{
B
C
B
I would like to Vlookup SaleCode in Code and get respective Record i.e No. in SaleNo.
Can any one help me perform this task

[damonreid]

Just make a query and link the respective fields.

[Twanne]

I use dlookup for this (I think). Don't understand exactly what you are trying.

varName = DLookup("The field you need", "The table you look in", "The value you want to match= " & The value you are searching)

[ritheshtitu1982]

Just make a query and link the respective fields.

thanks, and how do i link them in query. but i would like to perform a function similler to Vlookup in excell. im trying this

open update query > in the "field" name i gave name of the field where i want to up date > in the "update to" i gave Dlookup("field" ,"table name","field(in table i want to lookup data from)")

but im not able to lookup the values in the master table

how do i perform this task in access query, please explain step by step process

[damonreid]

Simply make a new query and pull in the two tables, Access should automatically like the the correct keys on the tables (if it doesn't you can do it manually). Then pull all your required fields down in to the bottom section of the query and when you run it the information will be linked by your key (what you would look up using a H/V/D Lookup.