null values in reports

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

I am building a report that contains several consecutive
fields, concatanated and separated by semicolons. Does
anyone know how to set up the report so that the
semicolons are not inserted if there is a null value in
previous field.
Any help appreciated!
Joanne
 
Use + as the concatenation operator instead of & between the field and the
semicolon:

(Field1 + ";") & (Field2 + ";") & (Field3 + ";") etc.

The + propogates the Null and "cancels" out the other character.
 
Ken is right about null propagation, but you would use
(Field1 ) & ( ";" + Field2 ) & ( ";" + Field3 )

HS
 
No, actually, you are right.
I had mis read the requirement. The poster wanted to vaporize the
semi-colon if the field preceding it was null

HS
 
Back
Top