Thread: Hide subreport and main report record if subreport running sum is zero in microsoft.public.access.reports

  Thank you for replying. I tried your suggestion. The subreport is hidden but the main report still displays those items. Marshall Barton wrote: >>My subreport and main report are linked via master and child relationship. >>The subreport has a running sum and I have placed it in the main report item >[quoted text clipped - 26 lines] >>What I would to do is only display those items in...

  forcefield via AccessMonster.com wrote: >My subreport and main report are linked via master and child relationship. >The subreport has a running sum and I have placed it in the main report item >footer. How do you prevent the subreport from not displaying that item if it >has a zero running sum? > >The structure of the main report whose record source is a query is as follows: >...