I am trying to count a field on a form if that field contains a certain word. For example, I want to count how many active cases I have. The fiel called [casetype] contains the word "active", "inactive" and so forth. I am using the =count([casetype])="active" but it doesn't work. Any help?


BAC

Bill I would try using the DCount() function for this:

=DCount("casetype","YourTableName","([casetype] = 'Active')")

(change "YourTableName" to the name of you table, it must be within quotes)

HTH
RDH

Thanks RD Hicks. It worked.


BAC

See also, the reply to my query under subject Count()

RD Hicks suggestion worked, however when I include date range criteria the dcount() function just shows #Error in the unbound text field and in the status bar at the bottom it shows Calculating . . .
Any reason why I cannot have the DCount() function is affected by date range criteria?


Thanks.

BAC

[This message has been edited by bill crumpton (edited 01-02-2001).]