Syntax for countin certain occurrences in a Report

[LA Lytle]

I need the syntax for a formula that will count certain occurrences in a field within a report. I want to exclude the blanks or nulls from the count. Currently I am counting all occurrences including nulls or blanks. =count([DD])

 

[pdx_man]

Take a look at the DCount function. Include the same criteria for your report and then add the criteria for the NOT Null and <> "".