Re: More summing problems
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Wed, 08 Aug 2007 16:14:46 -0500
Barry wrote:
I have a report in the form main report with 2 subreports. The subreports
are for customer and prospect calls. Often times there are no prospect calls
made on a particular day. In the footers of each subreport I have a control
that counts the number of records in each of the subreports. There are 2
controls on the main report to show the values of the counts adn reference
the fields in the subreport footers. So long as there are records in both
subreports the fields on the main report are filled in properly. When the
prospect subreport has no records I recieve #error in the field on the main
report. In the main report field I have tried;
IIf(subreport!CountField=0,0,SubReport!CountField) or
IIf(IsNull(SubReport!CountField),0,SubReport!CountField) and
nz(SubReport!CountField,0) and variations on a theme. Most work as long as
data exists in the subreport.
Check the subreport's HasData property.
=IIf(subreport.Report.HasData,subreport.Report!CountField,0)
--
Marsh
MVP [MS Access]
.
- Prev by Date: Re: saving report
- Next by Date: Re: saving report
- Previous by thread: Re: Need Help Summing Sales and Donations in Report Footer
- Next by thread: RE: Showing Unbound fields in form to report.
- Index(es):
Relevant Pages
|
