Translating Case Function into AppleWorks

[sdutton]

I need to set up a calculation in my AppleWorks Database that is the equivalent of the following formula in FileMaker:

If(IsEmpty(Man's First Name),Woman's First Name, Man's First Name & Case(not IsEmpty(Woman's First Name), " & " & Woman's First Name))

Any help?

Steve

[LiveOak]

There should be virtually no difference, AppleWorks has a calculation field and an "If" function. Just use an "If" in place of the Case function:

If(IsEmpty(Man's First Name),Woman's First Name, Man's First Name & If(not IsEmpty(Woman's First Name), " & " & Woman's First Name))

-bd