This question is perhaps more general SQL than IBO, but I am really
stuck. I want to run a report for our social service agency that
counts the number of persons served by ethnic break-down. 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

Any ideas will be greatly appreciated.

Lance Johnson
HelpNET of the Greater Denton Area