Null propagation in a query

[louise]

Hello,
I am trying to create an expression in a query where a field label only appears if the field has a value. I am using the + instead of an & as a way to (try to) do this.

For example, if the course has a size limit, I want the field to include: <sp><sp>Size Limit:<sp> followed by the value in [maximumsize] if there is one.


I have tried every permutation I can think of and cannot get it to work. Thanks for any suggestions!


TryNullProp: [CurrentSemester] & (" Size Limit: "+[MaximumSize])

[June7]

Is MaximumSize a number field? Try:

TryNullProp: [CurrentSemester] & (" Size Limit: " + IIf([MaximumSize] Is Null, Null, CStr([MaximumSize]))

http://allenbrowne.com/QueryPerfIssue.html

[louise]

Is MaximumSize a number field? Try:

TryNullProp: [CurrentSemester] & (" Size Limit: " + IIf([MaximumSize] Is Null, Null, CStr([MaximumSize]))

http://allenbrowne.com/QueryPerfIssue.html

Thanks very much! That did the trick.