Count instances of string w/in a field 1

[Buckaroo8]

Hello All,
I have a stored procedure which outputs two strings in a field on my report:
string 1 = "Acute Medical"
string 2 = "Behavioral Mngmt"

So I need to total the number of instances of both (done).

However, how do I total/count each individually:
"Acute Medical" = XX (times occurred)
"Behaviroal Mngmt" = XX (times occurred)
Total = XX (done)

Thanks for everyone's help!

 

[synapsevampire]

2 strings in a single field, or one of the 2 strings will be in a field?

Or???

Anyway, a simple means would be to use the instr() function to find if a string exists within another string:

instr("Acute Medical",{table.field}) > 0

So create a Running Total for each field and in the evaluate->use a formula place the above.

-k