If you are using access 2002, you can use the Replace function in an update query to replace a space with a + symbol.
If you are using an older version of Access, I have written a version of the Replace function which is available in the Tek-Tips database from my website
I am using 2002 version but cant see how i would update query to replace a value.
When i tried it replaced the whole field to "+" is there a way of restricting the update to just the "space".
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.