Label Calculation

[Nagasaki]

Hello,

I am trying to modify a label calculation, and it is telling me I am missing the operator. It must be the end of the day (or just cause I am a novice) but I don't see where I am missing one. Here is the calculation:

Case(not IsEmpty(Partner Name) ; Partner Name & " " & "and" & " " & First Name & " " & Last Name); IsEmpty ( Last Name ); Company; First Name & " " & Last Name

Basically, I am trying to have it search for a partner name; if there is a partner name put in "partner name and First Name Last Name. If there is no Last name, put in the Company; otherwise just do First Name Last Name. TIA

[Raybaudi]

Case(

not IsEmpty(Partner Name) ;

Partner Name & " and " & First Name & " " & Last Name ;

First Name & " " & Last Name

)

[mr_vodka]

Case (

not IsEmpty(Partner Name);

Partner Name & " and " & First Name & " " & Last Name ;

IsEmpty ( Last Name ); Company;

First Name & " " & Last Name

)

In your code, you had the closing ')' in the wrong place

Case(not IsEmpty(Partner Name) ; Partner Name & " " & "and" & " " & First Name & " " & Last Name[color:red]); IsEmpty ( Last Name ); Company; First Name & " " & Last Name [color:green])

[Raybaudi]

IsEmpty ( Last Name ); Company;

I didn't see that !

[Nagasaki]

Thank you very much! It's always the little things, isn't it?