(no subject)

Ok, so here's a question: I have a bunch of addresses in an MS Access file. The fields are Firstname, Lastname, Spousename, Street Address, State, Zip, etc. I'm trying to print mailing labels for Christmas cards, but at this point it would have been faster to do them by hand.

There's a Label Wizard in Access; I can use it to find the template for my Avery mailing labels, no problem. I can print the following:
Firstname Lastname
Address
City, State Zip

The problem is when there's a spouse. Then I want it to say
Firstname and Spousename Lastname
Address, etc.

Anyone have any idea how to do this?
I puttered through the manual about conditionals in reports and found you can theoretically do stuff like =IIF(IsNull(Spousename)," ",[Spousename])
which should give me a blank space if the Spousename is empty, else print the Spousename.
But the Label wizard says every way I try to put that in, it's a syntax error. It only appears to take fields, not fields with conditionals. Or there's some subtlety of Access syntax I'm missing (no white spaces? Square brackets instead of round ones?).

Or if I could figure out a way to filter, to print out all those without Spousenames first and then those with Spousenames, I could do it that way...

Grrrr. I do NOT want to go buy Access for Dummies just to get my Christmas cards done.