=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 (' ').
 
Back
Top