Neil Tompkins schrieb:
> Thanks Sebastian, but I now get the error message
>
> [MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function

i am not familiar with ODBC or MySQL 3.x

but possible just GROUP BY is missing
check the manual for your mysql version for the exact syntax

if this is not working at all you have to use HAVING

--
Sebastian