count the number of items in a field

[Guest]

I have my query setup and am building a report, one field in the query has
text, what I need to due is add up all the text values that equal "abc" and
display that in a total count, and also need to use a date range for the
data. Is this possible?

 

[fredg]

I have my query setup and am building a report, one field in the query has
text, what I need to due is add up all the text values that equal "abc" and
display that in a total count, and also need to use a date range for the
data. Is this possible?

THE ABC COMPANY IS PROVIDING THE ABC'S OF BUSINESS MANAGEMENT.
The query would return back a "2".


CountInString: (Len([FieldName])-Len(Replace([FieldName],"ABC","")))/3

The /3 part is whatever the number of characters in the search string
(i.e. "ABC") is.

To limit the query to a certain range of dates, as criteria on the
date field column, write:
Between [Enter Start date] and [Enter End Date]

You will be prompted to enter the 2 dates.