Works like a charm. Many thanks. Sometimes the simplest things are
the most obvious.

Lance Johnson

--- In IBObjects@y..., Nando Dessena <nandod@d...> wrote:
> 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