Thanks to all who offered a solution for this,
this works fine for me:
select JobNo, Type, max(Date) as LastDate from LogFile GROUP BY JobNo, type ORDER BY lastdate INTO cursor TransTmp
>>Hi
>>
>>I have a LOGFILE table, I was wondring if there was any SQL syntax where I could put into a cursor the last record of each
>>type for a given jobno
>>
>>transaction type is C (4), and could be "NEW","AMEN","DEL","WUP","MIX","MILL" etc
>>
>>Jobno is C(14)
>>
>>I want give the option of displaying the date & time that the last tranaction of each type happened for a given job into a grid.
>>
>>Any help extremley appreciated
>
>If all you want is to display JobNo, TransType, LastDate, then
>
>select JobNo, TransType, max(DateFld) as LastDate from LogFile GROUP BY JobNo, TransType
Rob