Only print groups with minimum number of records

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
 
F

Fons Ponsioen

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
 
C

chris

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
 
Top