COUNTIF in ACCESS (like in EXCEL)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to put together a query that counts each of 5 items in a field of a
table (how many "A's, how many "B's", etc.). In Excel I could use the
COUNTIF function but cannot seem to figure out how to do this in ACCESS.
 
Try this:

SELECT FieldName, Count([FieldName)
FROM TableName
GROUP BY FieldName
ORDER BY FieldName;
 
Back
Top