Hello,
I have several access tables containing 2 fields : "ID" and "Name"
I would like to update the content of the "Name" field.
In each line, I'd like to insert a string of characters before the current characters string contained in the "Name" field.
This string of characters I'd like to insert is made of the first 9 characters contained in the "ID" value.
So for example, if the ID contains "12345678_9101112131415" and the corresponding Name is "Jack_L", I need the updated Name to be "12345678_Jack_L" (because the first 9 characters of the corresponding ID are "12345678_"). The ID should not be modified.
How can I do this? (I am a newbie regarding this kind of thing)
I guess it's an update query, but I don't know how to build it, what the formula should be, and where to write it.
Thank you for helping me :-)