Error displayed in summary section of report with no data

  • Thread starter Thread starter Robin9876
  • Start date Start date
R

Robin9876

In an Access 2003 report which has a summary section which Sums a
value in the detail section, when there is no data #Error appears at
the Sum(myField) section. There is no sub reports on this report.

How can the #Error text not be shown when their is no data?
 
Robin9876 said:
In an Access 2003 report which has a summary section which Sums a
value in the detail section, when there is no data #Error appears at
the Sum(myField) section. There is no sub reports on this report.

How can the #Error text not be shown when their is no data?
Click to expand...


Try using something like:

=IIf(Report.Hasdata, Sum( . . . ), Null)
 
Back
Top