Concatenation

[Rhubie]

I have this expressions in a query - if seems if some of he fields are blank it does not concatenate the other fields - how do I get them to concatenate if there are blank fields?



ReportDesc: [KaratWeight]+" "+[Description]+" "+[Size]+" "+[TypeOfLeaf]+" "+[GramWeight]+" "+[Classification]

[pbaldy]

Hint: + propogates Nulls, & does not.

[June7]

Use & character for concatenation. The + character is old concatenation operator left over from ancient BASIC that VBA evolved from. It is also addition operator and math operations involving null result in null so in spite of the text values in the expression, Access returns null. Any other math operation with alpha strings would error.

[Andycam]

Hi

Try this:

ReportDesc: [KaratWeight] & " " & [Description] & " - " & [Size] & " " & [TypeOfLeaf] & " " & [GramWeight] & " " & [Classification]

Andycam