Report Criteria by Sum

[LLowrance]

I'm somewhat of an amateur writing reports in Access, so forgive me. I have written a report from a query where the report groups by company name. In the Group footer I'm counting the number of records. When I run the report I want to limit what is returned based the count in the group footer.
i.e.
=[RecordCount] > 3

I'm used to Crystal Reports where I can enter this in the selection criteria.

Thanks

L

 

[dhookom]

So you only want to return records where the company has more than 3 records?

If so, create a query similar to your report's record source except group by Company and count the number of records in a column named CompanyCount. Then add this query to your report's record source and join the company fields. Set the criteria under CompanyCount to >3.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]