Max Date?

[LGB]

This has to be too simple...but it's friday afternoon...
I have to select a memo field (I know...) based on the
update date in the same table for every selected account on the report. I want the memo from the most recent date.

How do I do that?

Thanks..

lgb

 

[rogar]

Group by account, sort within account by date descending, suppress details and display data in the group header. Or use a group selection formula Maximum({date},{account}).
Both of these solutions pull all records and filter on the workstation. You'll need more SQL than CR can do to filter on the server.