Search code examples
ms-access

Access insert into one row characters from other

I want to automate moving values from one row to other by using function like RIGHT, the thing is i need to take from one col (row) 2 last letters and put them into the other column but in the same id/row. ScreenShots should clear some things up.

enter image description here

Solution

  • You can run an update query.

    EDIT (Thanks to @Applecore):

    UPDATE tableName SET KodNrProjektu=RIGHT(NumerProjektu,2)

    Before:

    Before image

    After:

    After image