Summing in a Report

  • Thread starter Thread starter nazir.atif
  • Start date Start date
N

nazir.atif

=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?
Click to expand...


Try using:

=IIf(Report.HasData, Sum(Amount), 0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
#Error Count 2
#Error is returned on sum([FieldName]) 3
Subreport - No record creates #Error 4
Sum Check Box 5
Using the IsError Function 3
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Printing report for Invoice 0

Back
Top