exp vg
asked on
Access and separaing/modifying names - Resources
Can anyone please offer a resource on how to separate/modify name fields in Access. I use various examples from internet searching, and previously provided answers from EE - but Ii would love to have one or two thorough and comprehensive resources that will enable me to understand how the forumulas work (i.e. mid, left, right, etc)?
Thanks.
Thanks.
ASKER
Thank you for this - this is helpful.
It would be wonderful to have examples with Access SQL - since I so often make my own formulas, but they are never just right (that is when to use Right, Left, -1, +1, etc).
It would be wonderful to have examples with Access SQL - since I so often make my own formulas, but they are never just right (that is when to use Right, Left, -1, +1, etc).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
see the documentation herehere