update a column with its last value and concat to the value of another column

hello



i have the following code but it doesn't work can you help me please?

thank you



DoCmd.RunSQL (" update tbl_userinformation SET [05-Henrichpiramid] = Yes where Username= Text146.value AND actualdate=Text148.value ;")

DoCmd.RunSQL (" update tbl_userinformation SET [combination] = [05-Henrichpiramid] where Username= Text146.value AND actualdate=Text148.value ;")



i want to update the column combination to its last value with concatanation to the value of current column . can you help me please?

thank you

update a column with its last value and concat to the value of another column