I have a list of text entries and I want to count how often each entry appears in the list.
The result would be
This result easy do to achieve with an pivot table in MS Excel (see: Count Items in Excel). My data not in spreadsheet in Excel but in a MS Access database table. So in order to avoid constant switching between Access and Excel and I would like to handle everything in Access (either Access 2007 or 2010).
I know there are pivot tables in Access and I know how to display one, but I was unable to find out how to count the number of occurrences.