Lance,

> There is a
> field called "Ethnicity" which has a single character code. I want to
> count each row by the code. The return should look something like
> this:
>
> A 25
> C 37
> H 20
> O 7

select Ethnicity, count(*)
from Table
group by Ethnicity

should do.
Ciao
--
____
_/\/ando