By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,241 Members | 775 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,241 IT Pros & Developers. It's quick & easy.

Perform Vlookup function in access

P: 2
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
Jul 23 '07 #1
Share this Question
Share on Google+
4 Replies


damonreid
Expert 100+
P: 114
Just make a query and link the respective fields.
Jul 23 '07 #2

P: 65
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)
Jul 23 '07 #3

P: 2
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
Jul 31 '07 #4

damonreid
Expert 100+
P: 114
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.
Jul 31 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.