• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

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  
0
kgittinger
Asked:
kgittinger
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now