#error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am calculating a field which totals the sum of a report(Charges) and a
subreport(payments).

It works fine when there is data in the payment.

I get and #error which prints when there is no data in the payment
subreport.
What is the best why to have the payment subreport return 0(zero) if there
are no payments.
 
Stefan,

Use the HasData property of the subreport. For example...


=Sum([Charges])+IIf([YourSubreport].Report.HasData,[YourSubreport]![YourTotal],0)
 

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

Errors in Report total fields 19
SynNeed to account for null values in subreports 2
=iif Calculated field in report? 3
calculate when subrep has no records 2
Access ADP Report problem 1
The SubReport Data do not print 3
Summing from a Subreport 3
Running Total from a calculated value 2

Back
Top