I'd think there's probably an easier way using a query, on which you can then
base a simple report. If you can post details of the table(s) involved and,
if there's more than one, how they are related, along with an exact
description of what you want then hopefully I might be able to come up with
something.

I don't know what time it is where you are but its time to hit the sack
here, so I'll pick up anything you post tomorrow.

Ken Sheridan
Stafford, England

"Chey" wrote:

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.