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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppress total for first record of a group 1
Print each vendor's record on it's own page 3
Grouping problem with labels report form 6
Group Totals and Grand Totals on each page 3
Grouping records per sheet 1
Number of records in a group - Access 2003 2
Group Footer Summarizing Problem 5
Count number of records on a report page 2

Back
Top