Record Selection By latest Date 1

[ganjass]

CR 9

Hi all

I have a situation where i have distinct records with the same account codes that have different transaction times. I want to select only those that have the latest times how would i do this at the group level. I have 1 group by transaction code.

eg 1234 06/10/03 FER
1234 07/10/03 ASP
1456 06/10/03 DRE
1456 07/10/03 ASP


I want The ASP code for account 1234 and 1456

Thanks

 

[synapsevampire]

Use Report->Edit Selection Formula->Group:

{table.date} = maximum({table.date},{table.Account})

I've no idea what you mean by the ASP code.

-k