Help with Access for Lookup

aravindkm

New member
Joined
Mar 13, 2014
Messages
19
Reaction score
0
Points
0
Excel Version(s)
2013
Hi All,

Could anyone Please help me out with a lookup function in access where I have an identical data for 2 tables however I need a Employee salary to be picked from Table 2 to table 1.

See below the Table 1 & table 2 for your reference.

I need the salary in the table 1.

Table 1


IDEmployee IdEmployee Name
244130089Arun
344030188Kavitha
440031189Raja
540012289Ravi
640036719Ganesh
Table1



Table 2
IDEmployee IdEmployee NameSalary
144130089Arun600000
244030188Kavitha700000
340031189Raja650000
440012289Ravi675500
540036719Ganesh550000
Table2

 
aravindkm,

You don't need a formula in Access you just need to create a Join (join the two tables together) in your Access Query based on the Employee ID. You can then use the Query as the basis for your forms or reports and access any information in either table directly. Note: this does NOT change the structure of either table.

HTH :cool:
 
Hi geek,

Could you please let me know how to create a join between the two tables together.


Thanks
 
aravindkm,


  1. Create a new query.
  2. Add your to tables to the query design.
  3. Drag "Employee ID" from one table and drop it on top of "Employee ID" in the other one.
  4. Drag the required fields to the design grid from the desired table.
  5. View the report.

AccessQryDesign.PNG

AccessQryResult.PNG

HTH :cool:
 
Also, here is the SQL statement
Code:
SELECT Table1.[Employee Name], Table2.Salary
FROM Table1 INNER JOIN Table2 ON Table1.[Employee Id] = Table2.[Employee Id];
 
Alan, this thread is one year old. Not much chance of getting an answer...
 
Back
Top