I'm still in the dark. I found this example and tried using it and it is doing part of what I want it to do.
Here it is:
=IIf(IsNull(lastname])" ",[firstname]&" "&[lastname]&", "&[CompanyName])
This is what I get:
Jane Doe, XYZ, Company.
What I want is to show first and last name only if...