Skip printing selected records

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.
 

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


Top