Skip printing selected records

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have an access report that prints a count of how many times a company name
appears in the table. Example

Walmart 4
Target 5
Kmart 1

I am using the =count(*) to add the number of times the company appears and
this works fine. But, I only need to print the companies that are greater
than 1.

Can I use the >1 with the count function to selectively print only companies
that appear more times the one. And how do I write the Controlsource
=count(*)>1?????

Any help appreciated.
 
Back
Top