Counting number of occurences in a field

[Michael]

I have a field called "Classification" in a table. The
possible responses are "CA" or "CN". I would like to use
a query to count the number of times CA appears in the
field and the number of times CN appears in the field.

I would like to use a query to do this. Any tips?

 

[Brian Camire]

You might try a query whose SQL looks something like this:

SELECT
[Your Table].[Classification],
Count(*) AS [Occurences]
FROM
[Your Table]
GROUP BY
[Your Table].[Classification]