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

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???
 
D

Douglas J. Steele

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

Top