Thank you Rick.
>>Hello all,
>>
>>I'd like for the following code to work. The where is the important part that doesn't want to cooperate ;-)
>>
>>SELECT Field1, COUNT(IdCase) as TotCases;
>>FROM Table1 ;
>>group by Field1;
>>where TotCases > 3
>>
>>So to only get the rows where TotCases is greater thant 3 how should I code my where?
>
>Try 'having TotCases > 3' instead of 'where'
*******************************************************
Save a tree, eat a beaver.
Denis Chassé