Count how many times a word shows up in a field and calculate the %

[SeadnaS]

I have a field in my only table. Its a text field and only contains to words pass and fail i want to find out what the percentage of pass to fails is. Is there a way of counting the words and working out the percentage of passes?

Any help much appreciated.

 

[PHV]

A starting point:
SELECT [text field], COUNT(*) AS CountOf
FROM [my only table]
GROUP BY [text field]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

Thanks got a pie chart working! That may be suitable.