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
Table1
Table 2
Table2
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
ID | Employee Id | Employee Name |
---|---|---|
2 | 44130089 | Arun |
3 | 44030188 | Kavitha |
4 | 40031189 | Raja |
5 | 40012289 | Ravi |
6 | 40036719 | Ganesh |
Table 2
ID | Employee Id | Employee Name | Salary |
---|---|---|---|
1 | 44130089 | Arun | 600000 |
2 | 44030188 | Kavitha | 700000 |
3 | 40031189 | Raja | 650000 |
4 | 40012289 | Ravi | 675500 |
5 | 40036719 | Ganesh | 550000 |