Hello,

We have a mailing database, and we have it set up so we enter in the main person's first name in the first name field, and their last in the last name field. If they have a partner or spouse, then we enter the partner's full name in the field "partner"

What I want to do is set up a calculation field called "Label Name." So far I have First Name & " " & Last Name & " " & Partner Name. But what I want to do is set up a calculation that checks to see if there is a partner name, and if there is a partner name, include "and Parner Name." Otherwise what is happening is that my calculation is getting a result like "John Doe Jane" (Instead of John Doe and Jane). In the case there is no partner, I do not want my label field to read "John Doe and". Any suggestions? TIA!

First Name & " " & Last Name & If(not IsEmpty(PartnerName) ; "and " & PartnerName)

Thank you for your help, that worked perfectly! I thought it may be the If Is Empty function, but I wasn't sure since I was looking for a full field. I didn't realize you could be "not" in front of it. Thanks again!

:B