Hi all,
It's the newby team again. There are two parts to this question.
1.
For the life of us, we can't work out how to change a word to uppercase when it comes before a comma. (FYI, there is always a comma).
Eg. Doe, John
How do you make Doe, John into DOE, John.
2.
And if we have a Doe,John (without the space after the comma), how do we make it DOE, John (to include the space after the comma).
Any help would be most appreciated.
We have tried Left functions, Iif functions.... all sorts.