help with expression to leave field blank if one of the fields in expression is Null

**HParker** · 03-11-2019, 12:07 PM

Expr2: [SongTItle2] & " - " & [Composer2], IIf([SongTItle2]=0, "Null")

Right now is SongTitle2 is blank the field prints the dash. I would like it to show nothing if SongTitle2 is blank.

Help please?

**ranman256** · 03-11-2019, 01:13 PM

=IIf(IsNull([SongTItle2]),"",[SongTItle2] & " - " & [Composer2])

**HParker** · 03-11-2019, 01:26 PM

Perfect! Thank you

help with expression to leave field blank if one of the fields in expression is Null

Thread Tools

help with expression to leave field blank if one of the fields in expression is Null

Similar Threads

Calculated fields not showing totals when one of the items in the expression is a null value

How do I make expression field remain empty if expression equals zero?

Can I alter my expression so I don't have to manually enter zeros when either field 1 or 2 are blank

Expression builder does not show other query fields to add to an expression.

Hide Textbox Expression When Field Contents Have Null Values

Posting Permissions