AnsweredAssumed Answered

Is this a relational, calculation or summary problem?

Question asked by StaceyFingerle on Dec 31, 2011
Latest reply on Jan 2, 2012 by philmodjunk

Title

Is this a relational, calculation or summary problem?

Post

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.

For example:

Date (B) Amount (A)
12/20/11 100
12/25/11 2000
12/31/11 50

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.

Any suggestions?

Outcomes