vlookup in access ? query

C

Che S H

Hiiiiiiiiiiiiiiii,

how to use vlookup in ms access
pls send me anyone with simple example with 2 table
email me: (e-mail address removed)

example
1st table contain
id address
44040404 banglore katnataka
44050404 chennai tamilnad
40256125 hyd ap

2nd table ( i pasted from excel only in id column )
date id address
30-05-2013 44050404
28-08-2013 40256125

i want address in address column
thanks to every one who read my questio
 
R

Ron Weiner

Che S H wrote on 8/30/2013 :
Hiiiiiiiiiiiiiiii,

how to use vlookup in ms access
pls send me anyone with simple example with 2 table
email me: (e-mail address removed)

example
1st table contain
id address
44040404 banglore katnataka
44050404 chennai tamilnad
40256125 hyd ap

2nd table ( i pasted from excel only in id column )
date id address
30-05-2013 44050404
28-08-2013 40256125

i want address in address column
thanks to every one who read my questio

There is no Vlookup in Access. In Access we write Queries against
Tables using Sql statements. For instance here is some sql that
returns the ID and address columns from tbl1 and all of the matching
Dates from tbl2 where the ID's match.

Select tbl1.id, tbl1.Address, tbl2.date
From tbl1 Inner Join tbl2
On tbl1.id = tbl2.id

You will need to change your Excel Mind Think to a Relational Database
mind think. Databases are not Spreadsheets!

Rdub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top