Awach,

Convert Null values to zero with the Nz function. See VBA Help for further
information and options. Try:

=Sum(Nz([ActualAmount]))

Sprinks


"awach" wrote:

I have a continous subform where the user can enter a value [Actual Amount].
Then there is a value, named [Total], that sums all of those amounts:
Sum([Actual Amount]).

However, there is a case where there may not be any records entered. In
that case, I would like [Total] to equal 0.

I tried IIf(IsNull([ActualAmount]),0,=Sum([ActualAmount]) but it doesn't
seem to be working. Any ideas?