formula to select max

[deeya]

SQL SERVER, CR10

I have a table CALL_LOG

CALL ID SRL_NO NOTES
00001 1 TXT11111
00001 2 TXT22222
00001 3 TXT33333
00001 4 TXT44444

What i want to do is only select the most recent note so in this case 'TXT44444', what is the best way to do this?

I want the formula displayed in the CALL_ID Group...

Many Thanks

 

[lbass]

If you group on CallID and then sort ascending by the srl_no, all you need to do is drag the notes field into the group footer and suppress the details and group header sections.

-LB