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

SELECT V.Date, X.t_s_num
FROM
(SELECT max(Date) as Date
  FROM trackrd
	where ...) V inner join TrackRd X on V.Date = X.Date

This is from the top of my head...