Solved

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

Posted on 2009-04-12
3
543 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
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 92

Accepted Solution

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

910 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

24 Experts available now in Live!

Get 1:1 Help Now