I have one access table with
I have on description field for products whose contents look like this:
91255008 - MOTOR DE CORRENTE CONTÍNUA COM PASSO DE 0,065 GRAUS E POTÊNCIA
I need to pick the code "91255008" and insert in a CODE field that I already created in my access table. I want to handle code as text field.
The code length is not fixed but there is always a space and the "-" after it.
Please no programming on answer. I´m only familiar with query (you can post here the SQL version of the query) or maybe the picture of design mode of the query.