View Single Post
  #1  
Old December 20th, 2009, 01:47 PM posted to microsoft.public.access.reports
Steve
external usenet poster
 
Posts: 2,662
Default Eliminating Blank Fields from reports

Greetings:

Using the "+" to peform a "null propagation" as outlined in
http://office.microsoft.com/en-us/ac...494721033.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.

--
Steve