Using your formula I get:
Public, John James, (middle name but no suffix); needing Public, John James
Smith, Jane, (No middle name, no suffix); needing Smith, Jane
Jones, John , III (middle name with suffix); needing Jones, John, III
Now when a record has a middle and suffix it returns...
Relatively new to Crystal.
Trying to build statement to combine, Last, First Middle, Suffix. Not all names have a middle or suffix. So if there is a middle name I need a space between first and middle. Then if there is a suffix I need a [comma][space]suffix
So far I'm to:
{NMMAIN.LAST}&"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.