Combining IIF IsNull statements

[JobWK]

Unless I do not understand the IIF Is Null statement meaning but I am trying to combine this:

IIf(IsNull([SpouseLName]), ([SpouseTitle]),[Rank] & " " & [FirstName] & " " & [LastName] & " and Guest",[Rank] & " and " & [SpouseTitle] & " " & [FirstName] & " " & [MI] & " " & [LastName])

Please help

 

[jdraw]

Unless I do not understand the IIF Is Null statement meaning but I am trying to combine this:

IIf(IsNull([SpouseLName]), ([SpouseTitle]),[Rank] & " " & [FirstName] & " " & [LastName] & " and Guest",[Rank] & " and " & [SpouseTitle] & " " & [FirstName] & " " & [MI] & " " & [LastName])

Please help

What do you want to happen? Syntax is wrong as I see it.
Show us a sample of each side of the IIF, please.

 

[JobWK]

I want the results to be Mr. and Mrs. Joe E. Barnes or Mr. Joe E. Barnes and Guest or Mr. Joe E. Barnes and CPT Karen Barnes