Eliminating Blank Fields from reports

  • Thread starter Thread starter Steve
  • Start date Start date
S

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.
 
Use Str() around the numeric field:
=Trim([chrDataAlways] & ("; "+Str([intDataSometimes])))
 
Back
Top