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