Hi guys,
I would like to create a query that will deliver:
1. KRI_ID
2. DataDate
3. KRI Value
The difficulty is that I would like it to bring back each KRI_ID only once - only selecting the record with the most recent date available by using the DataDate field.
Any idea how I can get the...