Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Counting Values at end of report minus certain records

    Hello,



    I have a report that shows the serial numbers of cameras by location for our company. At the end of the report I do a count expression:

    =Count([Camera Serial #])

    This counts all the cameras in the report. My problem is that the report also lists dead cameras. I want to still be able to list the dead cameras under their location: Written Off/Dead ... but I want the count to exclude that locations cameras from the count. Is this possible? Thanks for your help...

    Blake

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Blake,

    Use an expression like this:

    =Sum(IIf([Status]="Dead",0,1))

    Modify the names/values as needed.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 10-23-2008, 12:08 AM
  2. Problem Selecting Records for a Report
    By Joe in forum Programming
    Replies: 0
    Last Post: 09-27-2008, 02:27 PM
  3. Creating top values with two records
    By avesamuel in forum Queries
    Replies: 0
    Last Post: 10-15-2007, 10:45 PM
  4. Counting records based on specified criteria
    By GrnISSO in forum Queries
    Replies: 2
    Last Post: 10-04-2007, 03:07 PM
  5. Replies: 4
    Last Post: 01-05-2006, 02:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums