Address Label Issue

[kwsrlt]

Hi,

I'm new to the forum and new to Filemaker Pro. My database knowledge is just from this past weekend -- I was able to figure everything out for my database that I will be using for the local animal shelter (keeping track of donors/members). I was able to utilize (with a lot of tweaking) the contact management database, but I have run into an issue with the address label.

I'm trying to figure out how to have names appear correctly on address labels. I thought that I had it with this calculation --

First Name & " & " & First Name 2 & " " & Last Name

It works fine when I want it to show "John & Jane Doe", but if I have only one person, the name line appears like this -- "John & Doe".

Any ideas/suggestions?

Thanks,

Ken

[sbg2]

First Name & If(not IsEmpty(First Name 2); " & " & First Name 2) & " " & Last Name

[kwsrlt]

It works perfectly! Thank you!