Profiles with different last names

[acls]

How do I get my custom report to display family members with different last names? I currently have the the following.

Mr. & Mrs John Doe
555 Oak St.
Columbus, OH 44995
John
Jane
Joe
Sue

Sue has a different last name from the rest of the family. How do I get that to show up in my custom report? How do I post a link to show what I have in my custom report?

Thanks,
Colleen

[Jeff]

In order to do something like this, you need to use conditional formatting. Your expression for the name field would need to read something like:

ALLTRIM(FirstName) + " " + IIF(UPPER(LastName_A) <> UPPER(LastName_B), ALLTRIM(Lastname_b), "")