Only print groups with minimum number of records

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

I'm working on a report with groups. Only groups that have at least 3
records should print. How can I accomplish this?

tia,
Chris
 
Hi.
I would create a summing query, where I would count the
ocurrences within each group, filter this to where this
count is >2 (which is 3 and above)
now include thi query in you underlying report for your
query relate them by what ever data element you are
grouping by.
This should produce the desired result.
Fons
 
Thanks for replying, Fons. I also thought off the approach you
suggest. The thing is, the underlying query for the report was already
quite complex and I worked more than an hour on it. I guess I hadn't
enough courage to create another quite complex query to filter the
groups, so I thought that maybe I could do something in the report
events. Meantime my courage got a boost so I created the query and it
is working fine, so thanks again for your reply.

regards, Chris
 
Back
Top