• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 596
  • 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  
1 Solution
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
what is the expression you are currently using?  What field are you summing?

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.  
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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