>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