View Single Post
  #1   Report Post  
Joop
 
Posts: n/a
Default avanced filtering for latest date

Hi, I have a question on (advanced) filtering of my database.

The database comprises of rows, each row representing an entry of the
database. Of some entries, the fields are indentical except for the
date field. Example:

Name value Vcc date
gain 3.2 2.7 3 jan 2005
gain 3.5 2.7 5 jan 2005
gain 4.0 3.0 5 jan 2005
ip3 -3 3.0 5 jan 2005


Now I want to filter the value for the "gain" at Vcc=2.7. I can do
that, but then I get to values: 3.2 and 3.5. How can I set up advanced
filtering to give me the latest value (the one at 5 jan 2005)?

Regards,
Joop