=COUNT() where column is blank/null returns ZERO

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report breaks on a column grouping and it prints a count of records using
=Count([column]
however when the column is blank or null, it prints zero instead of the correct coun
how to fix this???
 
From the Help file:

The Count function doesn't count records that have Null fields unless expr
is the asterisk (*) wildcard character. If you use an asterisk, Count
calculates the total number of records, including those that contain Null
fields. Count(*) is considerably faster than Count([Column Name]). Don't
enclose the asterisk in quotation marks (' ').
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if it is null how not to get the #error 1
Grouping and Counting null records 2
counting records 0
Count function showing #Error when no Record 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Line Counter in report 8
count expression results in Report and leave zeros blank in the to 4
Specialized Column Breaks 2

Back
Top