Calc Statement Maybe if statement

[agaperrk]

There is a Calculation involving 6 Fields I do not seem to get the right combination to work.

I have a First Name and Last Name Field

A Spouse Field and a Spouse Deceased Field

and a Deceased Field.

Case ( Spouse > 0; First Name & " & " & Spouse & " " & Last Name;

Spouse > 0 and Deceased Sp = "" ;First Name & " & " & Spouse & " " & Last Name;

First Name > 0 ;Full Name

)

I cannot get it to display correctly

I need the first name last name if no spouse

First name & Spouse Name if there is a spouse

"I get this one to work right"

I then need a calc to give the first name last name if the spouse is deceased

I then need a calc to give spouse and last name if the person is deceased

Thanks in advance.

I do not seem to get the check boxs to change the out come of the calc.

The deceased fields are check boxes I am using "yes" as the value.

[comment]

Try testing for IsEmpty ( Spouse ) instead of Spouse > 0 - assuming Spouse is a Text field.

[Fitch]

Try to think a little harder about the logical order. In your calc for example, [color:blue]Spouse > 0 and Deceased Sp = "" will never evaluate because when Spouse > 0 it will already have been handled by the first condition. I think what you want is this:

Case( 

/* I need the first name last name if no spouse */

  IsEmpty( Spouse ) ; First Name & " " & Last Name ; 



/* I then need a calc to give the first name last name if the spouse is deceased */

  Deceased Sp = "yes" ; First Name & " " & Last Name ; 



/* I then need a calc to give spouse and last name if the person is deceased */

  Deceased = "yes" ; Spouse & " " & Last Name ;



/* First name & Spouse Name if there is a spouse */

  First Name & " & " & Spouse & " " & Last Name

)

[agaperrk]

Try to think a little harder about the logical order. In your calc for example, [color:blue]Spouse > 0 and Deceased Sp = "" will never evaluate because when Spouse > 0 it will already have been handled by the first condition. I think what you want is this:

Case( 

/* I need the first name last name if no spouse */

  IsEmpty( Spouse ) ; First Name & " " & Last Name ; 



/* I then need a calc to give the first name last name if the spouse is deceased */

  Deceased Sp = "yes" ; First Name & " " & Last Name ; 



/* I then need a calc to give spouse and last name if the person is deceased */

  Deceased = "yes" ; Spouse & " " & Last Name ;



/* First name & Spouse Name if there is a spouse */

  First Name & " & " & Spouse & " " & Last Name

)

Thank you that is the best anyone has done to explain those calc

Thanks again.