access 2000 label wizard

[Guest]

In my database I have a field for title, first name, spouse's name, last name
etc. I want to print First name & Spouse's name Last name (if there is a
spouse.
If there is no spouse I just want first and last name on label.
I can only get it to print the labels like this:
If spouse then its OK it reads Carole and John Brown but... if no spouse it
prints:
Carole and Brown...which is not correct.
Do I have to do a query and put something in the criteria section or can I
just rpint it from the label and make it do what I need.
THANKS

 

[fredg]

In my database I have a field for title, first name, spouse's name, last name
etc. I want to print First name & Spouse's name Last name (if there is a
spouse.
If there is no spouse I just want first and last name on label.
I can only get it to print the labels like this:
If spouse then its OK it reads Carole and John Brown but... if no spouse it
prints:
Carole and Brown...which is not correct.
Do I have to do a query and put something in the criteria section or can I
just rpint it from the label and make it do what I need.
THANKS

In a query...
Exp: [FirstName] & (" and "+[Spouse]) & " " & [LastName]

Directly in an unbound control in the report:
= [FirstName] & (" and "+[Spouse]) & " " & [LastName]