I have formatted badges in Crystal, and need help sorting.
The name field is one field, which contains first, middle, last. Not everyone has a middle initial.
How do I sort by last name only? I'm using the StringAfterChar formula, but still not producing the results I need.
Ex. of badge names:
JOHN A. DOE
JOHN DOE
JOHN ALLEN DOE
Thanks!
The name field is one field, which contains first, middle, last. Not everyone has a middle initial.
How do I sort by last name only? I'm using the StringAfterChar formula, but still not producing the results I need.
Ex. of badge names:
JOHN A. DOE
JOHN DOE
JOHN ALLEN DOE
Thanks!