Hi kkshansid

I am a little in doubt. Is the field rmk a string? And are the purpose to add the character ‘1’ to the value in that field?
For instance, update the value ‘abc’ to ‘abc1’?

First of all, try to insert spaces:

Code:
CurrentDb.Execute ("update emp set rmk=rmk &*space*'1' WHERE ISDATE(LEFT(DOB,2) & " / " & MID(DOB,3,2)*space*& " / " & MID(DOB,5,4)
...