Error displayed in summary section of report with no data

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

Marshall Barton

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)
 

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

Using VBA to hide a report's detail section? 1
(headers & footers Issue) I have 2 even pages back to back!! 1
Passing values between reports 1
Detail_Format works in Print Preview but Not When Printing 0
[ACCESS 2003] REport: per page summary, total summary 1
Summing value in Grouped Section 1
Gouping In Sub Reports Leaving Windowed Headings 2
SynNeed to account for null values in subreports 2

Top