Counting characters in a field

J

Jim Jones

I need a query which will count the total number of incidences of specified
characters in a field. I then need the query to report the total number of
records for which this number is greater than a specified value.

For example, this morning I need to count the total number of incidences of
the characters *, A, B and C in a field called Results. I then need to
return and count the record if the total number of incidences is greater than
4. So, using actual examples, a field with a value of A*ABCEFG (5 incidences)
would count towards the total; GGUCC*BF (4 incidences)would not.

Any help would be appreciated.

Jim Jones
 
Top