>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'