How do I evaluate the 'Count' for a report header, footer, detail??

[tlyczko]

I want to print the headers and detail and footer only if Count([Name])
is >= 9.

How do I do this???

I am still searching this newsgroup too.

Thank you,
Tom

[Salad]

tlyczko wrote:

I want to print the headers and detail and footer only if Count([Name])
is >= 9.

How do I do this???

I am still searching this newsgroup too.

Thank you,
Tom

Dbl-click on the band to pull up it's property sheet. Maybe in the
OnFormat method you could enter something like
If Count([Name]) < 9 then Cancel = True
You may have to set a counter to inc over a group and reset it when a
new group starts.

[tlyczko]

That If... method does not work, I tried setting it in code...

I have names of people with dates of events attached to them, I want to
know if more than 9 events are attached to a person, and only print if
that person has 9 or more dates...I may be counting the wrong thing,
and I may be able to do the counting by using two queries, one to count
how many events per name, then a second query to filter out events >=
9, then base the report on the second query...

thank you, tom

[Salad]

tlyczko wrote:

That If... method does not work, I tried setting it in code...

I have names of people with dates of events attached to them, I want to
know if more than 9 events are attached to a person, and only print if
that person has 9 or more dates...I may be counting the wrong thing,
and I may be able to do the counting by using two queries, one to count
how many events per name, then a second query to filter out events >=
9, then base the report on the second query...

thank you, tom

That is the way I'd do it.