I have lines of detail being returned which have multiple database fields on them. I am trying to separate a specific field to build a formula from it. However, the detail lines could contain the "reset" field more than once and what i would like to see is just the latest one not all of them.

For example:-

 

reset    1/4/09   20

taken    2/4/09   2

taken    10/4/09  3

reset     1/7/09   17

 

If I ask for the sum of all values with reset - I get 37 back

How can I just ask to see the latest one only??

 

Many thanks in advance

Sarah