Help creating two listings from one record

  • Thread starter Thread starter SOMRev
  • Start date Start date
S

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.
 
Try this --
[FirstName] & IIF([SpouseName] Is Null OR [SpouseName] ="", " ", " and " &
[SpouseName] & " ") & [LastName]
 
Back
Top