formula to get a field value corresponding to another field vaue

[amd711]

I need to add a text box to my report that shows the value of a record in a certain field that is corresponding to a given value in another field.



for example, if my report shows the following:

N City

3 D
7 F
2 H
9 K
4 A

the text box should show the name of the city corresponding to the largest number which is in this case "K". is it possible through formula builder?

[pbaldy]

As answered elsewhere, try a DLookup() along with Max().