Help creating two listings from one record

[SOMRev]

I have extracted "members" from my database. One record will contain
LastName and FirstName, and may also contain SpouseName. Because I am
creating membership cards in Publisher, I think I probably should actually
create another query or ?? that contains one record with either [FirstName
LastName] or
[SpouseName LastName]

Probablyl something like ...
If SpouseName greater spaces List SpouseName LastName
else next sentence. List FirstName LastName

I don't have a clue how to do this in Access. Appreciate all help.

 

[KARL DEWEY]

Try this --
[FirstName] & IIF([SpouseName] Is Null OR [SpouseName] ="", " ", " and " &
[SpouseName] & " ") & [LastName]