Counting number of occurences in a field

  • Thread starter Thread starter Michael
  • Start date Start date
M

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?
 
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]
 
Back
Top