>>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.
>
>It's not a GROUP BY but the same rule applies, only aggregate functions can be used.
>
>

SELECT MAX(trackrcd.date), MAX(ALLTRIM(trackrcd.t_s_num)) FROM trackrcd ;

I need the specific trackrcd.t_s_num that belongs to the Max(date), so I don't think that will work.

Thanks anyway.