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.




Reply With Quote