#Error in the TOTAL Field when no records are present

[Guest]

I've create a simple record based to a query with a Total Field to summarize
my expenses. The record work with a range of date. If in the range of the
date no records are present, the value of my TOTAL field is "#Error".

Anyone can help me?

 

[Guest]

use something like nz([field to sumarise],0) in the summation

 

[Duane Hookom]

I doubt Nz() will work for this issue. Try
=IIf(HasData, Sum([FieldToTotal]),0)