Using a PivotTable to Count Items in Access
Posted
by
Sandra
on Super User
See other posts from Super User
or by Sandra
Published on 2011-04-19T15:24:03Z
Indexed on
2012/12/12
5:07 UTC
Read the original article
Hit count: 371
I have a list of text entries and I want to count how often each entry appears in the list.
e.g.
Berlin
Paris
London
London
Paris
Paris
Paris
The result would be
Berlin 1
Paris 4
London 2
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.
Thank you!
© Super User or respective owner