>>Can you post your select?
>
>

>SELECT TOP 40 New.Numero,New.Type,New.Titre,New.Message,New.Month,New.Year,New.Page,;
> New.Url,New.Creation,New.Titre_P,New.Titre_S,New.Message_P,New.Message_S FROM New;
> INNER JOIN NewAll ON New.Numero=NewAll.NoNews;
> WHERE NewAll.NoClient=tnZone AND New.Status=1 AND (NOT INLIST(New.Type,7,10);
>  OR (New.Type=7 AND New.Date>=ldDateEvent) OR;
> (New.Type=10 AND New.Date<=ldDateEvent AND New.DateFin>=ldDateEvent));
>UNION;
>SELECT New.Numero,New.Type,New.Titre,New.Message,New.Month,New.Year,New.Page,;
>  New.Url,New.Creation,New.Titre_P,New.Titre_S,New.Message_P,New.Message_S FROM New;
> INNER JOIN New AS New2 ON New.NoUserGrou=New2.Numero;
> INNER JOIN NewAll ON New2.Numero=NewAll.NoNews;
> WHERE NewAll.NoClient=tnZone AND New.Status=1 AND INLIST(New.Type,13,15) AND;
>  LEN(New.Message)>100;
> GROUP BY 1 ORDER BY 9 DESC INTO CURSOR Temp
>

When GROUP BY is used you can only include in the column list columns listed in GROUP BY or aggregate functions.