Count Items in Access 2003
- by Anna
I have a table which contains a column with different items which i would like to count by there type. For example the table looks like the following:
Id Type
1 Table
2 Table
3 TV
4 TV
5 Table
6 TV
7 TV
The result should looks like:
Type NumOfItems
Table 3
TV 4
I use the following code which doesn't work for my Access 2003:
SELECT Table1.Type, Count(Table1.Type) AS NumOfItems
FROM Table1