Removing commata from empty concatenated control

[TC2004]

The record source is
=[lastname]&", "&[firstname]&", "&[Degree]

For some records this particular information is empty and in the report I get
, ,

How do I prevent these commata from printing when the record is empty?

 

[KARL DEWEY]

Try this for no last name or no degree ---

=IIF([lastname] Is Null, "", IIF([Degree] Is Null, [lastname]&", &",
"&[firstname], [lastname]&", &", "&[firstname]&", "&[Degree]))

 

[Douglas J. Steele]

Or

=[lastname] & (", " + [firstname]) & (", " + [Degree])


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Try this for no last name or no degree ---

=IIF([lastname] Is Null, "", IIF([Degree] Is Null, [lastname]&", &",
"&[firstname], [lastname]&", &", "&[firstname]&", "&[Degree]))


--
KARL DEWEY
Build a little - Test a little

The record source is
=[lastname]&", "&[firstname]&", "&[Degree]

For some records this particular information is empty and in the report I
get
, ,

How do I prevent these commata from printing when the record is empty?