Hi All,
I am very new to ms access vba.
actually i have three tables like below. where as i want to compare the data for 1 employee for different month and based on that i want to update the required columns.
Please refer the attached file.
For example, i want to pick 1 employee and check if the designation of an employee is different compare to the last month then i update the column "promotion?" comparing with data from table 2 and table 3.
Simillarly other columns if there is a change in salary, then update the column increment?.
Please advise if this is possible using VBA in access.
thanks
Prasanta
Tabel 1 Table 2 Table 3 EmpID EmpName Designation Salary DataMonth Promotion? SalaryIncrement? Promotion+SalaryIncrement? Dcode Designation1 Dcode Designation2 1234 Ashok Asst Manager 5000 07/27/15 PM1 Asst Manager IC1 Executive 1234 Ashok Manager 5000 08/27/15 PM2 Manager IC2 Sr Executive 1235 Sameer Executive 4000 07/27/15 PM3 Senior Manager 1235 Sameer Asst Manager 5000 08/27/15 1236 Karim Sr Manager 6000 07/27/15 1236 Karim Manager 5000 08/27/15