I THOUGHT I'd solved this once before, but, for the life of me I can't figure it out.

I have a table, CaseAAGs with the following fields:
CaseAAGsID I (primary key)
CourtCasesID I
AAGCode I
DateAssigned D

I want to retrive the CaseAAGsID and the date assigned for the most recently dated entry for each CourtCasesID.

I've tried:
SELECT CaseAAGsID, MAX(assigned) AS latestdate;
FROM CaseAAGs INTO CURSOR CurrentCourtCaseAAG ;
GROUP BY CourtCasesID

But that gives me the wrong CaseAAGsID.

TIA j