sum in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report and in the footer I have an unbound field that has
=Sum[Cash_Amount]
I have also tried =Sum(Nz([Cash_Amount],0))
So my problem is this report may not have any information in it. If that is
the case then I want the result to be $0.00 right now it comes up blank.
The reason there would be no information is because of my query. The result
are comming back with nothing. Do you know a trick that might help me.
Thanks
Chey
 
Chey,

In the Format property of the calculated filed provide 0 for null value eg:

#,##0.00; (#,##0.00); 0.00;0.00

Regards/JK
 
Back
Top