By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,500 Members | 2,520 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,500 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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.
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.