?
Solved

Filtered Count

Posted on 2009-04-27
4
Medium Priority
?
321 Views
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?


Thanks


Kelvin
0
Comment
Question by:Kelvin Sparks
  • 2
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
Chris Luttrell earned 2000 total points
ID: 24247750
try
=Sum(IsNothing(yourfield.value),1,0)
0
 
LVL 22

Author Comment

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

Thanks for your help

What worked was

=Sum(Iif(IsNothing(yourfield.value),1,0))

Kelvin
0
 
LVL 22

Author Closing Comment

by:Kelvin Sparks
ID: 31575304
Good enough for good points. Thanks for your help
0
 
LVL 27

Expert Comment

by:Chris Luttrell
ID: 24250437
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.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

621 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