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

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  
kgittingerAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
what is the expression you are currently using?  What field are you summing?

mx
0
 
kgittingerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.