Search results

Hello, Many thanks for the quick response and guidance, I have used the "Mid" as suggested, and works great, I used the following; Address Road: Mid([Address L1],(InStr(1,[Address L1]," "))+1) I take on board what you also mention about not using spaces in the field names and will look to...

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...