Using Maximum in Record Selection

[ganjass]

CR 8

Hi Is there a way to use maximum in a record selection, that doesn't just bringing back an aggregate. I need to bring back all records of certain transactions where they where the last transactions for the accounts ie to bring back the transactions where the transaction codes are x, y,z where the transaction date is the last date on the record ie the max.

thanks in advance

 

[ganjass]

please ignore 1 cup of coffee later, all became apparent.