making address mailing labels

[mandp523]

Hi, I am relatively new to access. I have some things figured out, but not this!
In my access database, I have columns like this:
Last name First Name Spouse Name Address...
My problem is this. When I want to print out my mailing label, I would like it to be something like this:
**** and Jane Jones
I know how to put the "and" in there if both First Name and Spouse Name are filled. But, what do I do if there is only a First Name (no Spouse Name)? I don't want it to show up as
**** and Jones.
Is there some way to put the "and" in there only when both fields are full?
Thank you very much!

 

[Norie]

Where are you storing the surname?

 

[mandp523]

I am storing the surname under Last Name.

 

[Norie]

An expression like this may work:

IIf(IsNull([SpouseName]),[Firstname] & " " & [Surname],[Firstname] & " and " & [SpouseName] & " " & [Surname])

Replace the field names to match your own.

 

[mandp523]

Thank you very much!
So you live in Scotland! Isn't the internet great!
Thank you very much for all of your help!