>I have a table that has following itemno and positions.
>
>

>Itemno    Position
>
>0110.01   CPO
>0543.01   ACPO
>0543.02   ACPO
>0840.01   AC
>0840.02   AC
>3125.01   SC
>3180.10   WPT
>

>
>I am trying to to count distinct positions as follows:
>

>CPO  1
>ACPO 2
>AC   2
>SC   1
>WPT  1
>

>
>when I run this sql statement:
>
>

>SELECT DISTINCT cursor1.e_class FROM cursor1
>

Try

SELECT Position, count(*) as numoccurs from cursor1 group by position