Expression that has no Value

[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?

 

[Chris Freeman]

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

 

[tina]

try

=Sum(Nz([Original Check Amount],0))

hth