In the report foot a put a sum for detal section records (AMOUNT field).

All is ok when the detail section have records.

But when there's any record, the sum give an #Error.

I have tried =sum(Nz[AMOUNT]) , but the problem remains

What to do please?

Thanks

Check Out:
http://www.mvps.org/access/forms/frm0022.htm

Okay this method works. It's a shame the already built in Nz() or Dlookup or Dcount I have not received a good answer for. but I guess thats why we do have the option of using someones function, nnz.


What I had to do for this one, was reference my Calculation fields on my main form, and hide my calculation fields.

so I made new fields. set them to =nnz(calculation1) and so forth, and got the 0's to show up that way. allowing the rest of my form to function(totals)

Edited by: Snapper316 on Tue Sep 20 9:04:26 EDT 2005.

I just provided the answer.

I have used your function but I still get the same error (#Error)

:(

What could I do?

I referenced my field that had #error displaying in it...

So if #error shows up in txtCalc1

I made a new box called newCalc1 that had in the control source =nnz([txtCalc1])

Set txtCalc1 to visible=no. and used newCalc1 as my display box, it showed 0$ if #error was in txtCalc1


txtCalc1 by the way, has my =([field1]+5)*[field2] in it normally.

You also want to put the NNZ function in the global code.

Edited by: Snapper316 on Tue Sep 20 15:49:16 EDT 2005.