6 Replies Latest reply: Jul 15, 2015 12:32 PM by Stefan Wühl RSS

    Get most-recent value of one field based on date in another field?

      I am trying to get the most-recent value of field1 based on the value of another field (field2), which is a date.  For example, imagine a Score table that captures student's scores with three fields:  Student, Date, Score:

       

      StudentDateScore
      Chris7/14/1589
      Mark7/14/1592
      John7/14/1593
      Mark7/13/1587
      Chris7/13/1588
      John7/12/1590

       

      I'm trying to plot the student's name and last score in a table:

       

      StudentLast Score
      Chris89
      Mark92
      John93

       

      Any idea what that expression would look like?

       

      Thanks!