#Error in the TOTAL Field when no records are present

N

Netedp

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?
 
D

Duane Hookom

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