Report

[Peter Neumaier]

Hi NG!

I assigned following statement to a text box:

=Count([myColumn])

so nothing special, but I need also "the count" of all collumns that are
not null, how can I do that?
The appropriate SQL-statement would be(I tried to assign queries and
sql-statements to the text box, didnt work, maybe someone can paste
examples on that):

SELECT count(myColumn) where myColumn Not Null

Thx!

 

[Douglas J. Steele]

=DCount("*", "MyTable", "MyColumn IS NOT NULL")