vlookup in access ? query

  • Thread starter Thread starter Che S H
  • Start date Start date
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
 
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
Click to expand...

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
 
Back
Top