Delete all data after a symbol in a field

Joined
Apr 16, 2021
Messages
2
Reaction score
0
Hello, I have MS-Access 2007. In a Table field called ODOS, at the end of some entries, there is the symbol "&" and other words or numbers after that. I want the Symbol "&" of each entry and any letter or digit or word after that to be deleted. So if the entry is "John Smith & 123AB" It must remain just "John Smith". Can someone help me? (note that not all entries have the symbol "&" etc. entered.)
Thank you
Dimitris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top