generating mailing label reports

[Glider_man]

I’m an Access newbee and here’s my question. I have created a simple database of people names and addresses. Some of the people are married. Suppose I wish to generate mailing label report and insert the word “and” separating the first names of him and her but didn’t want the word “and “ inserted for single people. How do I do that?

[pbaldy]

What does the data look like (table structure)?

[Glider_man]

ID, Last Name, first name, spouse name, address…
Is this what you mean?

[pbaldy]

This type of thing should work. It takes advantage of the fact that "+" propagates Null and "&" does not:

=[FirstName] & (" and " + [SpouseName]) & " " & [LastName]

[Glider_man]

Forgive me for asking but where do I insert the code =[FirstName] & (" and " + [SpouseName]) & " " & [LastName] ?

[pbaldy]

That was an example of a textbox control source. The technique could also be used in a query or in code.

[Glider_man]

That worked, thank you.

[pbaldy]

Happy to help, and welcome to the site by the way!