Summing in a Report

nazir.atif · Apr 3, 2006

=Sum([Amount]) returns #Error if the query returns no results. How do I
convert this #Error to a neat 0?

Dennis · Apr 3, 2006

Try:

iif(isnull(Sum([Amount])),0,Sum([Amount]))

Marshall Barton · Apr 4, 2006

=Sum([Amount]) returns #Error if the query returns no results. How do I
convert this #Error to a neat 0?

Try using:

=IIf(Report.HasData, Sum(Amount), 0)