vlookup in access ? query

[Che S H]

Hiiiiiiiiiiiiiiii,

how to use vlookup in ms access
pls send me anyone with simple example with 2 table
email me: ***@gmail.com

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]

is anybody expert in group ?
pls solve

Post by Che S H
Hiiiiiiiiiiiiiiii,
how to use vlookup in ms access
pls send me anyone with simple example with 2 table
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

[Ron Weiner]

Post by Che S H
Hiiiiiiiiiiiiiiii,
how to use vlookup in ms access
pls send me anyone with simple example with 2 table
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