I am actually trying to achive something else, but tried this route first
I have a query and all I want to do is view a select part of data.
I want to see if a provider has had a check box for a period of 6 months.
So what I did was make a report with a vendor number
and on my subreport the months. Everything looked okay until, I did the
formula
iif a field is greater than 6 then visable if not then null. That worked
to. However I had to many blank pages.

Now what. Any suggestions.


"Ken Sheridan" wrote:

Are you saying that you want to hide the subreport if it has no data? If so,
reports have a NoData property, so you can hide the subreport 'control', i.e.
the control in the parent report which houses the subreport, by putting code
in the Format event procedure of whichever section of the parent report
contains the subreport:

Me.MySubreportControl.Visible = Me.MySubreportControl.Report.HasData

Ken Sheridan
Stafford, England

"Chey" wrote:

So I took out all the labels
But I have a field that is invisable, then on top of that I have a formual.
Then I have a subreport that I have done the same with.
How do I get the subreport to do the same?
I don't want any blank pages.
Thanks