|
| 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
July 12th, 2004, 09:04 AM
|
|||
|
|||
Countif function on a report
I have a report with a field in the forms detail called cases. If I put a text field the footer and set the control source to = count(cases) then it counts the records in the detail.
How do I change this so that it only counts where cases is 0. Is there an equivalent countif function in access? Bruce 
|
|
#2
July 12th, 2004, 10:03 AM
|
|||
|
|||
|
Countif function on a report
Bruce,
Try it like this... =-Sum([Cases]0) -- Steve Schapel, Microsoft Access MVP Bruce wrote: I have a report with a field in the forms detail called cases. If I put a text field the footer and set the control source to = count(cases) then it counts the records in the detail. How do I change this so that it only counts where cases is 0. Is there an equivalent countif function in access? Bruce
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
| COUNTIF function and Advanced Filter | wawrzyniak | Worksheet Functions | 1 | April 9th, 2004 06:06 AM |
| Problems with COUNTIF function for Date fields | roopasreeni | Worksheet Functions | 1 | September 24th, 2003 03:03 AM |
Linear Mode
