IIF statements

  • Thread starter trilliums zjik discussions
  • Start date
T

trilliums zjik discussions

I am stuck with the following Iif statement and would appreciate any
assistance:

=IIf([Suffix] Is Null,"([FirstName] & "" & " " & [LastName]",([FirstName] &
"" & " " & [LastName] & "" & ", " & [Suffix]))

Thanks in advance.
 
A

Allen Browne

Try:
= [FirstName] + " " & [LastName & ", " + [Suffix]

This uses a subtle difference between the + and & operators:
"A" & Null => "A"
"A" + Null => Null

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"trilliums zjik discussions"
 
Top