Show only groups with 6+ members 1

[ChrisCalvert]

I have a report and it has been requested that I have a companion report that just shows the Groups that have more than 6 members. I am hoping that someone could help with as suggestion on how to do this. I have added a count to the group footer, but I am not sure if this helps,and am a bit stuck at this point. . Would I maybe use a copy of the query and report, but add some kind of Dcount or something?
Thanks in advance for any assistance.

-Chris

 

[dhookom]

You need to create a totals query that groups by whatever field and counts the number of records. Add this query to your reports record source so that you can filter based on the CountOfWhatever >=6.

Duane
MS Access MVP

 

[ChrisCalvert]

I have a question about the totals query. What I need are phone agents who scored perfect (100) on 6 or more calls in a given month. I have:
-----------------------------------
Field, Total, Criteria

EmployeeNumber, Group By, -
Score, Where, 100
Date, Where, #DateParameters#
CallID, Count, >=6

-----------------------------------

However, if I try to pu other fields in here, such as Employee Name, or other data, that I don't want to sum or average or anything, I have to select something on the totals row. What would I choose? Or must I make another query that uses this one?

 

[dhookom]

Group By

Duane
MS Access MVP