Filtered Count

Posted on 2009-04-27
Last Modified: 2012-05-06
I have the field WarrantNumber. Within each scope (group) I need to COUNT the number of records that have a NULL (Nothing) value. What is the correct expression to achieve this?


Question by:Kelvin Sparks
    LVL 26

    Accepted Solution

    LVL 22

    Author Comment

    by:Kelvin Sparks
    Was almost correct, but close enough for me to see the light!!

    Thanks for your help

    What worked was


    LVL 22

    Author Closing Comment

    by:Kelvin Sparks
    Good enough for good points. Thanks for your help
    LVL 26

    Expert Comment

    by:Chris Luttrell
    Glad you got it working.  I knew I was forgetting something in that line, thats what I get for trying to use my memory instead of looking it up.  Thanks for giving me the credit.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
    Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now