Trailing ",'" when joining text field without value 4

[patyavila]

The report displays a calculated [field1]& ", " & [field2], when field2 is empty I have a trailing semicolon as result.
I will appreciate help...

 

[ByteMyzer]

Try:
[tt][field1] & IIf([field2] Is Null,", ","") & [field2][/tt]

 

[scriverb]

Try this:

[field1] & IIF(NOT IsNull([field2]), ", " & [field2], "")

This code checks a null value and if so only returns an empty string to be appended. If data is found then the comma(, ) and the field value is appended.

Good luck.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[PWise]

try [field1] &[/color ] ", " +[/color ] [field2]
The difference concatenating with an ampersand and a plus sign is that when you concatenate with a plus sign it only adds the value if all values are not null

 

[patyavila]

Thanks a lot to all you guys!

Patricia