In my database, I have a table named: Table1
I have a text field named: Test
The data in that field is like this: RAI-220101-001 (RAI-year-month-day-sequential number)
I want to execute a query that will modify all the records in that table so the data looks like this: RAI-220101-0001
I want a zero to be added after the 11th position (sequentiel number with 4 digits instead of 3)
As an example, In my current table, I have values that range from RAI-220101-001 to RAI-221231-1500. So I have values with 3 and 4 digits after the 11th position.
I want to be able to update all my data so that the values that have only 3 digits after the 11th position adds a zero at the 12th position and does not alter the data that already have 4 digits after the 11th position.
So to resume
the data shows RAI-220101-001 and RAI-221231-1155 and I want the update to display RAI-220101-001 and not change RAI-221231-1155 which already have 4 digits after the last -.
test.accdb
I want to do this using an append query...I guess!
Thanks for you help :-)