Is this a relational, calculation or summary problem?
Seems like this should be so easy, but I just can't manage it...
Simply put, I need Field C to show the value of Field B for the record with the maximum value in Field A.
|Date (B)||Amount (A)|
Field C should show the date on which the amount was highest, i.e. 12/25/11. Or, turned around, the amount for the most recent date.