Count occurance of number in a field

[davidoco2010]

I am reporting on an access database. I am extremely restricted in the number of fields I can use (UCCX cra-db and custom call variables).

The following is a sample table

Year Agent Type
2009 B 23
2009 B 26
2008 C 1
2009 A 5
2009 B 3
2009 C 21

The numbers can come in any order so IF > 1 etc will not work.

How do I count the number of occurances of each number in the column Type field. For example I want to see (from above)

Type Occurances
1 2
2 3
3 2
4 0
5 1
6 1


Thank you

 

[davidoco2010]

Problem solved

 

[lbass]

Please explain your solution so others can benefit from this thread.

-LB

 

[davidoco2010]

It's so simple - I'm shocked it was overlooked.

We used a filter formula of

{Field} like *2*

in a cross tab to report on occurances.