This will take out the first name. I think that the Left and InStr will work in SQL, if not, you can create a public function in a module to do the work and call the function from your query.
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.