I am trying to work on making my address book database a little friendlier. So when I print labels (like for my Xmas cards that havent been sent yet- hurry!) I am trying to set up a calculation field for the name of the recipient. My database has a First Name field and Last Name field and also a Value List Field called Send To Family? that can be checked yes or no. So, for example, if I have it checked "No", then I would like the calculation result to read <First Name> <Last Name>. but if "Yes", I would like it to read "The" <Last Name> "Family". How do I write this??

I have tried an If, but I cant get it to work by adding field contents into the results. Here is what I had- can someone fix for me? I'll put in a good word with Santa if you can..

If(Send to Family? = "Yes", "The" + Last Name + "Family", First Name + Last Name)

Hi Jay,

If(Send to Family? = "Yes", "The " & Last Name & " Family", First Name & " " & Last Name)

LaRetta

Wow! Thanks so much- it's perfect! Except I dont have an excuse anymore..