How to post/update a field of a previously posted records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table name: OtData
Its fields are: ENames,OtDate, Timefrom, TimeTo, Remarks etc.
There are about 25 employees working on overtime every day, which I post
related to these employee only and it is about more 5000 records.

I have another seprate table Name: EmpCodes
Its Fields are : EmpName, EmpCode, DtJoin
Its the data of only 25 employee, which I have mentioned above. But here I
posted all the 25 employee names and its codes etc manually, without
connecting to the above table. For example :
Rahul RAH
Sohan SOH

Now I have instructed by my Boss to add a field to the Table : OtData
The additional Field is: ECode

Means each record I posted in the Table OtData, should also have the code.

so, what ever Data i will post now onward, I can type the code, But the
problem is the previously posted data.

Therefore, I am looking for a solution, where I can run Updata query to
update the previously posted record. I mean, where the name will match It
will collect the Empcode from the other table and will update the first
tables field (which is been later on).

Could any of the professional can advise.
 
Back
Top