I'm new at this concatenation deal. I have four fields that I need to string together and I'm just not getting it right. I continually get error messages either "this text constant does not end with a quotation mark" or "A number, text constant, field name or "(" is expected here."
The first name and last name fields will always have data. The AKA and Previous Last Name field may be empty.
I would like the final string to be formatted in this way:
First Name "AKA" Last Name (Previous Last Name)
This is the calculation I'm working with right now:
=FirstName &" if( not IsEmpty (FirstNameAKA); " " & FirstNameAKA;"") & Lastname