Select Specific Row from Many

[MikeCopeland]

Using CR 8.5...
I have a situation that requires I select a specific record from a linked Table - and I don't know how to do it. Here's the data:
//-------------------------------------------
TABLE1
Key: 5411
TABLE2
Key: 5411 Date: 1/23/2007 etc.
Key: 5411 Date: 6/15/2007 etc.
Key: 5411 Date: 9/01/2006 etc.
Key: 5411 Date: 4/28/2006 etc.
//-------------------------------------------
Here I want to select/use only the data in the 2nd record (the one with the highest date). Unfortunately, although I can sort the selected rows on the Date and thus get the TABLE2 data ordered, I don't know _which_ of the
selected records is the one I want until I "see" them all - all are potentially qualifying, but I want only the highest date.
Is there a way to do such a thing in CR 8.5? Please advise. TIA

 

[Madawc]

There's the Maximum function for dates. Or if you sort a group by date, then the correct record will be in the header or footer and can be displayed there. It's common to suppress the details and show just the header or footer.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10