Hi All,
I have this set of data
| Claimant Type | Claim Number | Ver No | Payment Reserves | Recovery Reserves | Payments | RI Recoveries | Non RI Recoveries | | |
| AD | RS100202 | 1 | 925.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| AD | RS100202 | 2 | 925.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| AD | RS100202 | 3 | 925.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| PI | RS100202 | 1 | 4585.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| PI | RS100202 | 2 | 4585.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| PI | RS100202 | 3 | 4585.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| TP | RS100202 | 1 | 1000.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| TP | RS100202 | 2 | 1000.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| TP | RS100202 | 3 | 1000.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
I wish to return the maximum Ver No and then the corresponding data with that row ( See Below ). I have used the MAX function in an expression to select the maximum Ver no. What expression can i use to return the string which corresponds with the rest of the data on the Max Ver No field?
| Claimant Type | Claim Number | Ver No | Payment Reserves | Recovery Reserves | Payments | RI Recoveries | Non RI Recoveries | | |
| TP | RS100202 | 3 | 1000.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| PI | RS100202 | 3 | 4585.00 | 0.00 | 0.00 | 0.00 | 0.00 | | |
| AD | RS100202 | 3 | 925.00 | 0.00 | 0.00 | 0.00 | 0.00 | |
Thanks in Advance
Regards
James
.png "Miguel_Angel_Baeyens"){kind=avatar}
