Expression that has no Value

  • Thread starter Thread starter Chris Freeman
  • Start date Start date
C

Chris Freeman

I have a simple report that has an unbound field with a formula:
=Sum([Original Check Amount])

But when the [Original Check Amount] field is zero, I get the error, "You
have entered an expression that has no value"

How do I work around this?
 
Let me correct this, since I can't delete it, the field orignally returns an
#ERROR# value on the report. Then I tried to place an If me.[Original Check
Amount].value Is Null then, text.16.value = 0. But when I do so, I get the
"...expression that has no value" error emssage.

Thanks
 
Back
Top