Try: Sum(Nz([Cost]))



"ABaggott" wrote in message
...
I am trying to set up controls on a form that will return the count and
the sum of values in a subform and show 0 if there are no records in the
subform. I set up controls in the form footer of the subform using (for
example) Nz(Sum([Cost],0). This returns an accurate sum of the cost field
if there are records in the subform, but the field seems to be null if there
are no records in the subform. I have done the exact same thing in a
different set of forms and subforms in a different database, and it works
there; but I cannot get it to work in this one. It's driving me straight up
the nearest wall. Anybody have any ideas?