Count the number of time a word appears in a field

[bf2mad]

Hi,

I have a problem where I need the count the number of times three different words (Resolved, Reassigned, Rejected) appear in a field (Actions) in the results of a query (Desktop Datasheet Query). These three totals will then need to be displayed on a form which is based on the same query.

Can you please help.

Thank you very much

 

[Hasit]

Which application are you using?

 

[bf2mad]

Sorry MS Access 2000

 

[vb5prgrmr]

Well, you have two ways of doing this. The first is a count(*) query with the same criteria as the data sheet view, or you could run through the recordset and count then yourself (which will take longer and cause more coding on your part).

Good Luck