?
Solved

How to count null or 0 values in an Access Report?

Posted on 2009-04-12
3
Medium Priority
?
584 Views
Last Modified: 2013-11-28
How to total null or 0 values in an Access Report?  The Sumation button allows for count of records or values.  It counts " " and 0  I need to count the " " and or 0 valuese  
0
Comment
Question by:kgittinger
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 75
ID: 24126851
what is the expression you are currently using?  What field are you summing?

mx
0
 

Author Comment

by:kgittinger
ID: 24126954
I want to count non events.  It is currently  =Count([event_date])  I want to say if no value or the original load date of say "1/1/1990"  to show a count of non transactions.  
0
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 1000 total points
ID: 24127027
0

Featured Post

Python: Series & Data Frames With Pandas

Learn the basics of Python’s pandas library of series & data frames and how we can use these tools for data manipulation.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Suggested Courses

765 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