The way to do this depends on the database.
The basic idea is to first write a function that will transform "A", "B", "C" ... into 4, 3, 2. Then use SUM() to add the value of that function instead of COUNT(*).
For example, in Oracle
you should be able to do
In Microsoft Access, you can probably do
(but this only works if overallrecommendation is never null and never anything other than A, B, C, D, E. Might be better to use Access IIF).
[ November 26, 2002: Message edited by: Michael Zalewski ]