[RESOLVED] Count(fld) help :(

I have a table that looks like this

VB Code:

|---------|----------|
| received |  checked |
|---------|----------|
   Mr T     |     Mr M   |
   Mr T     |              |
   Mr T     |      Mr T  | 
   Mr M     |              |
 ---------------------

I need to count the number of times of received and checked.

The problem is when i use Count(checked), It gives me value 4 (I'm assuming it also counts the empty fields ) when it should be 2.

So my question is, what formula should I use? Or I am using Count(fld) the wrong way?

Please help and enligthen me.. Thanks in advance.

Please give me some quick help dudes.. :) thanks

Count does not include a record if the field is null. I would assume your "empty fields" actually contain an empty string, thus are included in the count.

You could use a Running Total instead. In the Evaluate section, select "Use a Formula" and write something like

Length(Trim({Table Name.checked})) > 0

Thank you Mr Bruce :thumb: