Why the Balance value shows #Error if the subreport has no data..? 2

[awinnn]

Hi,
I have report and subreport. This is what i have on the report.
Balance = Total - Subtotal.

The Balance is works fine if the subreport has data. The Total value is taken from the report while the Subtotal value is taken from the subreport. If the subreport has no data, the Balance will show #Error.
This is what i've done,
Balance = [Total] - nz([Subtotal])
whereby,
Subtotal = [Subreport_name].Report![total]

It doesn't work..Any idea?

Thanx..

 

[dhookom]

The Subtotal control source should be set to:
Subtotal = IIf([Subreport_name].Report.HasData,[Subreport_name].Report![total],0)

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[awinnn]

Hi Duane..
thanx for your help..it works..

* star for u..