N nazir.atif Apr 3, 2006 #1 =Sum([Amount]) returns #Error if the query returns no results. How do I convert this #Error to a neat 0?
=Sum([Amount]) returns #Error if the query returns no results. How do I convert this #Error to a neat 0?
M Marshall Barton Apr 4, 2006 #3 =Sum([Amount]) returns #Error if the query returns no results. How do I convert this #Error to a neat 0? Click to expand... Try using: =IIf(Report.HasData, Sum(Amount), 0)
=Sum([Amount]) returns #Error if the query returns no results. How do I convert this #Error to a neat 0? Click to expand... Try using: =IIf(Report.HasData, Sum(Amount), 0)
