How can we apply vlookup in ms Access ?

[jskushawah]

How can we apply vlookup in ms Access ?

Is this possible?

 

[smittal]

Hello Jitendar,


You can apply vlookup in Access with the Help of Joins...Let me explain.. you have two tables with same fields (Vlookup criteria).. just select the field of 1st table and without droping match the same field in second table.


now, a join is exists and when you double click on that then you can set your own join properties.


Just try and if any issue please let us know

 

[jskushawah]

I have 2 tables, tbl1 and tbl2, in first table i have following field:

Emp_code Emp_name Basic Hra Convnc. other

tble2 have the same fields, now I have an Emp_code in tbl2 and want to fetch all related values from tbl1 for that emp_code , how can I do this using join ??


thanks in advane.

 

[smittal]

just select the tab1.emp_code and drag the same to tab2.emp_code.. then you will be able to see the line, which called Inner Join.


https://www.dropbox.com/s/aiswifqwc4y8bed/Reservation_master.accdb


link is attached here. just open and try too read Booking_cancellation Query in Design View