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:
I'm trying to plot the student's name and last score in a table:
Re: Get most-recent value of one field based on date in another field?
Date is a dual function and you don't have to reuse another Dual() on top of it. My guess is that the reason Stefan asked you if Date is dual is not, is because there are times when Date is not recognized as date or when you create date this way Month(Date) & '|' & Year(Date). The above two may look like dates, but they are actually text which cannot be sorted by FirstSortedValue() function.