>I get the above message with the following sql statement:
>
>

>  SELECT MAX(trackrcd.date), ALLTRIM(trackrcd.t_s_num) FROM trackrcd ;
>	WHERE ALLTRIM(trackrcd.client_id) == thisform.idclient AND;
>	ALLTRIM(trackrcd.prjt_num) == thisform.idproj AND ;
>	ALLTRIM(trackrcd.task_num) == thisform.idtask ;
>	INTO ARRAY datearray
>

>
>Anyone know why? This is not a group by situation.

How can you use MAX if there is no GROUP BY? Also don't use ALLTRIM in your select statement.