Sum a field on in a report not working

[Jon123]

I have a field on a report footer that I want to dispaly the totals in. In the control source I have this code

=Sum(Nz([Number of Children],0))

If the report has a blank value it errors out. How do I get it to
ignor blanks or see then as 0 ?

jom

 

[GinaWhipp]

The field in the Detail section that you *Number of Children* is the one you want to use the Nz() funtion with OR, as I prefer to do, use the Nz() in the query and then Sum() on the report.