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.
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 ??