Needing an if statement in addition to adding two fields together

[mneumann25]

Hi,
I am trying to come up with a way to have two fields seperated by a comma on a report. Normally, I would just use
=[Last Name] & ", " & [First Name]
However, there will not always be a first name, in which case I want the report to just display the last name without a comma behind it...any suggestions on how to do this???

Thanks!

 

[CosmoKramer]

Try setting the control source to something like this:

=IIf(First Name] Is Null,[Last Name],[Last Name] & ", " & [First Name])

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams

 

[mneumann25]

MY HERO! Thanks so much!!!

 

[dhookom]

Replace the second "&" with "+".
=[Last Name] & ", " + [First Name]
If First Name is null then ", " also becomes Null.

"abc" & Null = "abc"
"abc" + Null = Null

Duane
MS Access MVP