Help with layout using various field data

[sebastosh]

Hello,

I'm a complete beginner at this, my inquiry may be completely dumb..

I have a layout that is meant to printed.. it displays data from certain fields..

ie: Hello <>,

is it possible to add an additional field input ?, only if there is data in the second field?

ie: Dear <> and <>,

yet, if no data is in "field 2", then only field 1 is display... without the word "and" as well.

I know this might be very easy, but after searching I don't where to start..

Thanks for any help possible.

[aldipalo]

Welcome to the Forum.

Make a calculated field (Salutation) with the following calculation:

Case(

Not IsEmpty(LastName);FirstName & " " & LastName &":";

FirstName &":"

)

hth

[sebastosh]

Wonderful, thanks!

I'm not in office to try this but will post results when I do.

thanks for a prompt reply.

great forum!