View Full Version : Syntax for countin certain occurrences in a Report


LA Lytle
03-02-2001, 10:31 AM
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
03-02-2001, 12:46 PM
Take a look at the DCount function. Include the same criteria for your report and then add the criteria for the NOT Null and <> "".