Counting fields

[Wayne1158]

I need to get a total of the number of times a certain word appears in a feild. The feild is a value list which has the words Active, Canelled in it. I just need to know how many records are set to Active. Whats the best way to go about this? thanks.

[aaa]

Create selfrelation by this field, then use count() function.