Hi Sergey,
Thanks for the input.
I have attempted to modify as required and this is where I am at. I get the error:
SQL: Queries of this type are not supported.

SELECT inmates.cid, inmates.cinmate_number, acct_events.tdatetm, acct_events.cstatus ;
FROM acct_events, inmates;
WHERE inmates.cid + TTOC(acct_events.tdatetm,1) IN ( ;
SELECT acct_events.cid + TTOC(MAX(acct_events.tdatetm),1) ;
FROM acct_events ;
GROUP BY cid) ;
INTO CURSOR crsLastEven NOFILTER