Count Text

[JT]

I would like to count how many times Pass is enter in the
results colum. Can some help me with it.

 

[Chris]

Try..

Select count(*) from YourTable where ResultsColumn
like '*Pass*';

 

[John Spencer (MVP)]

Wow! You sure gave us a lot of clues on what your query/table/fields look like.

PERHAPS something like:

Select Abs(Sum(FieldA = "PASS"))
FROM YourTable

Or even simpler
Select Count(FieldA) as CountField
FROM YourTable
WHERE FieldA = "Pass"

Or
DCount("FieldA","YourTable","FieldA=""Pass""")

Without a little more detail on what you are trying to do, the above is a guess.