Eliminating Blank Fields from reports

[Steve]

Greetings:

Using the "+" to peform a "null propagation" as outlined in
http://office.microsoft.com/en-us/access/HA011494721033.aspx
by Sal Ricciardi does not seem to work when the data is numeric. Is there a
work around for this?

For example:
=Trim([chrDataAlways] & ("; "+[chrDataSometimes]))
where chrDataSometimes is text data. This works!

=Trim([chrDataAlways] & ("; "+[intDataSometimes]))
where intDataSometimes is numeric data. This produces an error).

Thanks for any help.

 

[Allen Browne]

Use Str() around the numeric field:
=Trim([chrDataAlways] & ("; "+Str([intDataSometimes])))