Well I’m not sure this is exactly what you’re after but it may help a bit. You could set one of the columns in your query to being:
MyCount: IIf(instr([FieldName], strFindWhat),1,0)
Which would tell you if there is a match in that field or not, but it sounds as if you've already got something that does that. You could elaborate on the above if there are 2 or more different things to find in each record:
But this doesn’t tell you the number of matches in each field, only if there is or not. You could write a function which counted the number of matches given a string to search and string to search for, eg:
MyCount: CountMatches([FieldName], strFindWhat)
But I'm not sure you could do this if you aren't using Access to run the SQL itself. If none of this helps let me know as I'm sure there must be a way of doing it, maybe putting the search criteria into a temporary table and doing some weird IIf statements using IN ...
Some food for thought but you are right about the IIf I am useing
"Where [field] like *STRING*"
which gives only the records with at least one example of the search text in the field. ideally I'd like to count at least the first five (in which case if more than four count = lots (5) ). It's not VITAL just very important.