Hello, I was wondering if anyone can please help me, I have created a query in an access database and one of the fields called "Address L1" contains the first line of an address, I want to remove the first word or numbers before the first space (from the left) and display the remaining part in a new field;
For example, the existing text with the field is;
125 Green Road
I want to have the following in a new field;
Green Road
I have managed to extract the first word or characters before the first space that I need for another field and was trying to use the following for the above but returned the last two characters instead!
Expr1:Right([Address L1],(InStr(1,[Address L1],""))-1)
I would really appreciate any help.
Many thanks
Peter
For example, the existing text with the field is;
125 Green Road
I want to have the following in a new field;
Green Road
I have managed to extract the first word or characters before the first space that I need for another field and was trying to use the following for the above but returned the last two characters instead!
Expr1:Right([Address L1],(InStr(1,[Address L1],""))-1)
I would really appreciate any help.
Many thanks
Peter