Count Records that are not null

[depawl]

In a report, I want to use the "Count" function to count the number of records in a column, but only if the field contains data. In other words, if I have 10 records, and 5 of them have data in the subject field, the total of the count should be 5. I can't use a running sum b/c the field is not numeric.
thanks so much

 

[RuralGuy]

You can however use an invisible control on the report with its ControlSource set to =IIF(IsNull([YourTargetControl]),0,1) and set the RunningSum as you like.

 

[depawl]

Thanks RuralGuy, It took me awhile to get it right but your answer is what got me there. Appreciate the help.

 

[RuralGuy]

Glad I could help.