Remove the last "and" in a concatenated name field

[Gina Maylone]

I think I have done this 100 times, but my think is broken. I have a concatenated name field (Comboname) "Doe, John and Jane Doe".

ComboName: IIf([SpouseLastName] Is Null And Not ([Spouse] Is Null),[LASTNAME] & ", " & [FIRSTNAME] & " and " & [Spouse],[lastName] & ", " & [firstname] & " and " & [spouse] & " " & [SPOUSELASTNAME])

For those without a spouse, I need to remove the trailing "and", I am using this;

Member: IIf(Right([comboname],8)=' and  , ',Left([comboname],Len([comboname])-8),[comboname])

Honestly, I don't even know where that function came from, or what the "8's" mean. It is not working. Maybe my comboname needs more work. I don't know. So tired of this database.

Any thoughts always appreciated.

[Gina Maylone]

I got it sorted:

ComboName: IIf([SpouseLastName] Is Null And Not ([Spouse] Is Null),[LASTNAME] & ", " & [FIRSTNAME] & " and " & [spouse] & " " & [LASTNAME],IIf([spouselastname]<>[lastname],[spouselastname] & ", " & [spouse] & " and " & [firstname] & " " & [lastname],[lastname] & " , " & [firstname]))