If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Skip printing selected records
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. -- Mike |
#2
|
|||
|
|||
Skip printing selected records
Check out the answer to my post "How conditionally display stuff on a
report?" "Mike" wrote in message ... 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. -- Mike |
Thread Tools | |
Display Modes | |
|
|