I expect you do do this in datasheet with a simple Find and Replace.
Sent: Monday, October 24, 2016 2:21 PM
Subject: [MS_AccessPros] Find Replace in Access
All data in my FirstName field begin with open bracket e.g "(Vino". How can I take out the open bracket with a query? Also for my LastName field which contains closing bracket at the end of the name, e.g "Padayachee)".
Posted by: Duane Hookom <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (4)|